💻 Software

Excel 2007 transpose/combine multiple rows into one

Fresh5 days ago

Mar 15, 20265689 views

Confidence Score0%

Problem

I have data like so: I need to transpose/combine the rows that have matching values in the first column with a final result like so: 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?

Error Output

1001NCCN    3618127
1001NCCN    208478
1001NCCN    207316
1001TEMN    409889
1001TEMN    801651
1001TEMN    273134
1001TEMN    208478
1001TEMN    207…

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Excel 2007 transpose/combine multiple rows into one

Low Risk

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...

Awaiting Verification

Be the first to verify this fix

Excel 2007 transpose/combine multiple rows into one

Problem

Error Output

1 Fix

Fix for: Excel 2007 transpose/combine multiple rows into one

Environment