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.

[#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

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

     Tables=>Split

Click on OK and it will create a new data table