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

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

Did u ever find a solution to your problem? if not, i might be able to
help. Reply to this message if the problem still exists and u need a
solution!


--
gohoos02
------------------------------------------------------------------------
gohoos02's Profile: http://www.thecodecage.com/forumz/member.php?userid=412
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105397