How to group duplicates in a column and simultaneously link to the corresponding text in another column.
Ex., What I have.
Column 1 Column 2
DAN-4153 GBD567
DAN-5608 GBD567
DAN-325 GBD1321
DAN-4178 GBD590
GBD4730
What I want.
DAN-4153
DAN-5608 GBD567 (in one row)
DAN-325 GBD1321
DAN4178 GBD4730
GBD590
Bookmarks