Group by and Concatenate all record

[Simon1187]

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  

[atcodedog05 · Accepted solution]

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 🙂

[Simon1187]

Hi @atcodedog05 

Thanks very much.