How to get the one specific column value from the duplicate rows

Hello Smart People

The table is sorted, and it has some duplicate rows(the value of the city are the same).
For those, i like to write the name who are living there, spearated by “,”

i am using the add rows actvity ,the error comes out.
1.Add the very first rows to the another dt by using add row activity.
2.from the second row, check that the precvious row of the city data is the same of the current row(second row)
3.if same, write the people name spearated by ,

after all rows are done, write the csv.

Thank you in advance. (3.1 KB) City.xlsx (10.5 KB)

Hi @eimon ,

One basic solution is as follows:

Here is the starter help file DuplicateCity.xaml (12.2 KB)

Hope this helps
Best regards,