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.