combining data with the same ID and the similar variables

[moonstal]

I have a large data set (about 1000 rows long), but it actually refers to
only 160 IDs with several (common) variables for each.
Example:

ID Var1 Var2 Var3 Var 4 etc

1 Var1
1 Var3
2 Var2
2 Var3
3 Var1
3 Var4\

And I need it to look like:

ID Var1 Var2 Var3 Var 4 etc

1 Var1 Var3
2 Var2 Var3
3 Var1 Var4
etc.

I have played around with sort, filter and as many of the reference and
logic functions as I can wrap my head around but I can't get excel to combine
the rows with the common IDs so that the variables common to those IDs are in
one row. Any help would be amazing!
Andrew

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Amazingly difficult.
http://www.mediafire.com/file/wz1zmyjznda/06_11_09.xlsm