I have an Excel sheet with data organized like:
1 A
1 B
2 A
2 B
2 C
I want to reduce the first column to unique records, and have the second column listed on the same row. (I'm assuming I'll need Access to do it.) Is there a way to produce a table like this?
1 A B
2 A B C
The final result would need to be something I could put back into Excel.