I've never been able to find an easy way to do this...I have a spreadsheet with the following format:

ID | Data1
1 | A
1 | B
2 | C
2 | D
3 | E

And I want:


ID | Data1 | Data2
1 | A | B
2 | C | D
3 | E

Any suggestions?