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.
@yekho
have a look on this xaml as it is similar to your case:
GroupBy_1Col_StringAggregation.xaml (9.0 KB)
Thank you, ppr!
It was helpful.
I have additional questions.
Can you set multiple keys for “group by”?
@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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale