Hello Everyone,
I've got a spreadsheet where I have duplicate data in column A but unique data in column B. What I'm attempting to do is move the unique data in column B into new columns where there is a duplicate in column A. Very confusing to state but examples are great things.
Currently:
A B
3100377 25602010
3100377 25602213
3100377 25602310
What I need it to look like:
A B C D
3100377 25602010 25602213 25602310
Anybody know a way of doing this?
Bookmarks