Merge text based in another column value

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:

Screenshot 2021-07-30 at 13.55.18

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

Hi @Mateus_Coelho :wave:

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!

1 Like

Amazing! I knew have an easy way to do that :wink:

Thanks @Adam_R

1 Like