I have a table with two columns "code" and "dates". There are duplicates in the code column but each duplicate has an corresponding unique date. I want to eliminate the duplicate codes and have the unique date values put next to each other under a single row for a given code word.
Example:
as 98
as 76
as 76
bc 54
de 32
rf 54
I want a table as:
as 98 76 56
bc 54
de 32
rf 54
I have also attached a sample sheet for further reference. Any help is appreciable.
Thanks
Bookmarks