How to combine values from multiple rows into a single row in Excel?
Fresh3 days ago
Mar 15, 2026213212 viewsConfidence Score0%
0%
Problem
I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this: I'm stuck with a row for Customer 1 for Value A in 2009 and a separate row for Value B for the same c…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to combine values from multiple rows into a single row in Excel?
Low Risk
This is VBA, or a macro you can run on your sheet. You must hit alt+F11 to bring up the Visual Basic for Application prompt, go to your workbook and and paste this code in there. You can then run the module from within VBA by pressing F5. This macro…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix