Hi!
I hope my subject line was somewhat descriptive.

I have the following problem:
1. Column A of my extremely huge spreadsheet contains id numbers.
2. ID numbers appear more than once, because the same case is spread across multiple rows (i didn't set this thing up...)
3. I need each unique case to be in one single row.

Basically, I need to convert ...

A B C D
id1 1 2 1
id1 3 4 5
id2 2 1 5
id2 9 2 3

...to

A B C D E F G
id1 1 2 1 3 4 5
id2 2 1 5 9 2 3

Added difficulty:
The number of rows over which one unique case spreads is not constant. E.g., I have 10 id1, 20 id2, 15 id3...


Can anyone help? I'd be forever grateful!

as