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.
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
