I have a situation where I need to merge rows with variable column values in Data Table based on a primary key.
I have tried several methods with no success.
Yes, actually I have a situation where the first field of the row is key which can be duplicate with different values as mentioned in Input Data Table. I need the consolidated list for a Key in single row without loosing any information in value fields.( Duplicate values are allowed for non key fields.).
then i got max number of rows to add that many columns for our data.After getting the max number i added that many columns using Add range method can also be done by using for each and add data column activity
then i wrote all the data of a specific id in a sheet and added it in our new DT which was created from above step.