Merge two rows with one column with different values into 1 row with both values

[vanast]

Hi,

I have the following issue. I have a set of data with multiple rows and different columns. I made a simple example that should solve my problem.

This is the  example data that i have. If the values of ID is the same then i want to have a combined field in location separated by a value. How can i solve this in my script?

ID	Location
1	New york
1	Amsterdam
2	Tokyo
3	Barcelona

This is the table that i want to have

ID	Location
1	New york, Amsterdam
2	Tokyo
3	Barcelona

Thanks in advance for your help!

[Or · Accepted solution]

This is a use case for Concat(), seemingly:

Load ID, Concat(Location, ',')

From YourTable

Group By ID;

[vanast]

Thank you for this. It worked!