combining data with the same ID and the similar variables



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

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

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!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question