Consolidating Repeated Values

[#1]

I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)...

Any help would be greatly appreciated. Below is an example of before and what I would like after.

S_Boilermaker_0-1718048662396.png

S_Boilermaker_1-1718049072147.png

[#2]

Easy task

Create a new column.  I called it Sequence and give it the Formula

Col Cumulative Sum(1, :ID)

It will give a sequence number for each row for each separate ID it finds

txnelson_0-1718052245330.png

Now all that has to be done is to use the Split platform to split the data into new columns

     Tables=>Split

txnelson_1-1718052357331.png

Click on OK and it will create a new data table

txnelson_2-1718052406912.png