Group by and Concatenate all record

Question

Hi everyone!

I hope you are well!

I want to find duplicates phone number and then concatenate business names together and put them in a new column and chose  the first row and stick the concatenate business name near the row.

Would you please help me with that how can I do this process simple then what I did.

Please find the attached files.

Thanks, Simon

Concatenate.yxmd

concatenate Business Name.xlsx

atcodedog05 · Accepted Answer

Hi @Simon1187

This is how you can do it.

Workflow:

1. Unique tool : keep unique records based on FormattedPhone number

2. Summarize tool : Groupby FormattedPhone and concat BusinessName

3. Join tool : Join on FormattedPhone (i,e this is similar to your append tool). Concat row joins on all rows with phone number.

Hope this helps 🙂