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?
Best Answer
Here's a VBA solution
it relies on like rows being grouped, so sort first if you need to
Just select the first cell in your range and run...