Hi,
I am trying to combine duplicates entries in one column, while preserving the unique information in each row from the duplicate.
A1; B1; C1
A2; B2; C2
A3; B3; C3
into this:
A1; B1; C1; B2; C2; B3; C3
So that if A1=A2=A3 and they are therefore duplicates, it will combine the information in each row by adding a new column.
I actually have a larger data set (i'm talking hundreds of thousands of entries) that I need to do this with.
I attached a snippet of it. I am trying to merge any duplicates from the first column (Desy_Sort_key) so that there are only unique numbers there, but without losing information from the other columns.
Thanks!
Bookmarks