6
1
I have data like so:
1001NCCN 3618127
1001NCCN 208478
1001NCCN 207316
1001TEMN 409889
1001TEMN 801651
1001TEMN 273134
1001TEMN 208478
1001TEMN 207316
I need to transpose/combine the rows that have matching values in the first column with a final result like so:
1001NCCN 3618127 208478 207316
1001TEMN 409889 801651 273134 208478 207316
I looked at Pivot Tables, and filtering but neither seemed like they can give me what I need. Is there a way to do this within Excel?
I don't have an answer, but it might matter, so: is the data sorted on the first column? Specifically, do you know if every instance of
1001NCCN
(and the like) will always be adjacent to one another, or is it possible to have them split? – DMA57361 – 2011-02-11T14:20:52.670@DMA, Yes every instance is adjacent to one another. They are not sorted alphabetically but I can do that if needed. – jzd – 2011-02-11T14:37:55.973