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.