group and concatenate

[LEXQ2005]

In the data source, one Product has multiple Locations. I want to transform the data in table 1 to table 2 - each row has a unique Product name and separates the Locations for the product using ";". 

[JosephSerpis · Accepted solution]

Hi @LEXQ2005 I mocked up a workflow let me know what you think? The Summarize tool can group and also concatenate your data at the same time. 

[LEXQ2005]

I like it! Thanks. 

I found one issue after I plugged it into the big data source. For example, in the attached data file, each product has 24 locations. However, the Summarize result only shows 12 locations in Excel. 

[afv2688]

Hello @LEXQ2005 ,

I have tried to runt the process and got all the info on both cells.

Are you limiting the characters on some tool? It is being limited to 255 characters

Regards