Combine like duplicates into one record

[wonka1234]

Hi,

Based on 1 or more columns, how can I combine my rows into one, separating with a ";"?

Col1	Name
CO-C12	louis.stevens@hotmail.com
CO-C12	louis.stevens@hotmail.com
CO-C12	ren.stevents@hotmail.com
CO-C12	ren.stevents@hotmail.com

into 

Col1	Name
CO-C12	louis.stevens@hotmail.com;ren.stevents@hotmail.com

[JosephSerpis · Accepted solution]

Hi @wonka1234 you can use a combination of a unique tool and summarise tool to achieve your desired results.

[Felipe_Ribeir0]

Hi @wonka1234 

You can use the summarize tool to do it. Just remove duplicates before it

[grazitti_sapna]

@wonka1234 , For this case you just have to use a combination of unique and summarise tool to achieve your desired result. Here is the workflow for it.

[ShankerV]

Hi @wonka1234 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V