combining data with the same ID and the similar variables

M

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
 
G

gohoos02

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!
 

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

Similar Threads

VBA - Function Output 2
Assign a single variable to an Array filled with same data types 7
VBA - get result from 1
Make all variable values in a Array equal to 0 8
Make all variable in Array = Empty each click of a Button on Userf 5
How to convert the string to variable? 6
Matrix to a Column Report 8
variable available after userform 2

Top