topic Re: Consolidating Repeated Values in Discussions

Consolidating Repeated Values

S_Boilermaker — Mon, 10 Jun 2024 19:52:30 GMT

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.

Re: Consolidating Repeated Values

txnelson — Mon, 10 Jun 2024 20:46:53 GMT

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