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