Convert duplicate value rows to list(datatable)

[yekho (Porori)]

Hi, all!

I have an excel data table like below.

Rows of “ITEM_ID” may be duplicated.
The classification can be “ROW_NO”.
For rows with duplicate “ITEM_ID”, the two values are converted into a list.
For non-duplicate rows, enter the value directly.

I want to create a new data table as shown in the image below.

Please, Help.

[ppr (Peter Preuss)]

@yekho
have a look on this xaml as it is similar to your case:
GroupBy_1Col_StringAggregation.xaml (9.0 KB)

[yekho (Porori)]

Thank you, ppr!
It was helpful.

I have additional questions.
Can you set multiple keys for “group by”?

[ppr (Peter Preuss)]

@yekho
yes, the group by can be formulated for multiple rows. Have a look on a demo defining 3 key cols here:
GroupBy_3ColKey_MergeSimulate.xaml (11.6 KB)