Combining duplicate strings in an array

I have a paired string array of 6-digit xyz coordinates which shows the presence of a edge between two nodes.

x = {'010510' '050110' '1'

'020610' '060210' '1'

'010510' '050110' '1'

'050110' '010510' '1'}

I would like to convert this into a weighted edge list using column 1 and 2 data to generate the following:

y = {'010510' '050110' '3'

'020610' '060210' '1'}

Presumably this needs to use unique and accumarray, however it is a requirement to keep the data as a string of 6 digits and not lose 0's at the start...

Grateful for any working solution!

Answer 1

[JESUS DAVID ARIZA ROYETH]

solution:

[m,n,l]=unique(join(sort(x(:,1:2)')'));
y= horzcat(split(m),cellstr(num2str(sum(repmat(n',size(x,1),1)==l)')))