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 ";".
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.
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.
