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.
Testbr.zip (3.1 KB) City.xlsx (10.5 KB)