Merge text based in another column value

[Mateus_Coelho]

Hey Guys,

I think it’s quite simple what I want to do, but I cannot figure out the best way to achieve what I’m looking for.

Check it out the screenshot below:

In the column “City” you will find duplicate values and I want to remove the duplicate and merge the text on the “unique id” column based on the “City” column, achieving the following results:

Any ideas of the best way to achieve what I’m looking for?

[Adam_R]

Hi @Mateus_Coelho

This is a great use case for our Merge duplicate rows step. Using that step, you can build the following logic…

Merge these columns Unique ID per unique value in these columns city

This should do the trick – let me know if you run into any issues!

[Mateus_Coelho]

Amazing! I knew have an easy way to do that

Thanks @Adam_R

[Mark_Berry]

I think I have a slightly different use case, but maybe similar ?
I’m wanting to merge duplicate phone numbers into the minimum possible columns from Right to left. See example data