Excel 2007 transpose/combine multiple rows into one.
- by jzd
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?