Merging Rows based on unique ID

[Vsridharan]

Hi , 

I have been trying to figure out a way to merge the data based on unique ID where if the data in a column for different records (with the same Unique ID) is different then merge the data separated by ";" however if the data is the same then just reflect that data as is.

I have attached a file that has a sample data of both the input and output to provide a better picture of the problem statement.

Would really appreciate advise on the best possible solution for the same.

Thanks,

V

[CPSlater]

Should be your answer.

[Vsridharan]

Hi @CPSlater,

Thank you for your response.

I am not sure if the file you uploaded is just an input file, because I am unable to see the solution.

Would be great if you could upload it again.

Thank you,

V

[JosephSerpis · Accepted solution]

Hi @Vsridharan you can use the summaize tool to group your data based on Unique ID and concantenate the data.

[CPSlater · Accepted solution]

Done - apologies!