nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

763053_en-US

liliconcom

Consolidating Repeated Values

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.

Automation and Scripting

Content Organization

Data Access

Data Blending and Cleanup

Data Exploration and Visualization

Windows

Re: Consolidating Repeated Values

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