Excel Pivot Tables: How to flatten a cross tab table (aka unpivot / reverse pivot in Excel 2010)
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: https://go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: https://go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: https://go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: https://go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: https://go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: https://go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
https://go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
When you have a cross tab table you might want to flatten it to make it easier to analyse. This is also known as unpivoting or reverse pivoting or converting a summary pivot table into a normalized data table.
In Excel 2003 you would use the pivot table wizard with Multiple consolidation ranges to do this. In Excel 2007 and 2010 the pivot table wizard is not accessible from the Excel ribbon, so you must either add a button to your quick access toolbar or use a keyboard shortcut to bring up the pivot table wizard (press ALT, press D, press P)
As you watch the video tutorial you may find it helpful to pause, so you can follow along in Excel. If you found this video helpful, click on the like button or share it on Facebook and Twitter, or write a comment.
Thanks!
Victor
P.S. Check out this link to an Unpivot Utility, if you are interested in doing this with multiple columns http://spreadsheet1.com/unpivot-data....