combining data with the same ID and the similar variables
- From: moonstal <moonstal@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Jun 2009 12:21:01 -0700
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
.
- Follow-Ups:
- Re: combining data with the same ID and the similar variables
- From: Herbert Seidenberg
- Re: combining data with the same ID and the similar variables
- Prev by Date: Re: Blank cell not really blank
- Next by Date: Re: Count occurences in string
- Previous by thread: Counting unique values with criteria
- Next by thread: Re: combining data with the same ID and the similar variables
- Index(es):
Relevant Pages
|
Loading