How to "unpivot" or "reverse pivot" in Excel?
Problem
I have data that looks like this: And I want to convert it to this: What's the easiest way to do this in Excel 2007?
Error Output
Id | Loc1 | Loc2 | Loc3 | Loc4 ---+------+------+------+----- 1 | NY | CA | TX | IL 2 | WA | OR | NH | RI
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: How to "unpivot" or "reverse pivot" in Excel?
You can do this with a pivot table. Create a "Multiple Consolidation Ranges PivotTable." (Only on Pivot Table Wizard. Callup with ALT+D, P on Excel 2007) Select "I will create my own page fields". Select your data. Double click on the grand total value - the one at the intersection of Row Grand and Column Grand, all the way on the lower right hand corner of your pivot table. You should see a new sheet containing all of the data in your pivot table, transposed in the way you're looking for. Data…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix