Pivot Table Tutorial: How to flatten a cross tab table
When you have a cross tab table you might want to flatten it to make it easier to analyze. Here is a 3 minute video to show you how to do this using Excel’s pivot table wizard to import multiple consolidation ranges. I also show you how to add the pivot table wizard to your Quick Access Toolbar if you’re using the new flavor of Excel (2007 or 2010).
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)
Excel Pivot Tables: How to flatten a cross tab table
(or how to normalize your data)
As you watch the video tutorial on Youtube you may find it helpful to pause, so you can follow along in Excel.
The process I show in the video is also known as normalizing your data. If you find the tutorial helpful, I’d appreciate if you shared this page on Facebook, LinkedIn or Twitter using the buttons below. Thanks!
Get Free Updates
Learn how to use Excel more effectively and stay up to date with the latest articles and videos from Launch Excel (it's free).
Plus... get a bonus PDF with more than 100 popular Excel shortcuts, FREE when you sign up today.
- Results of the Excel Pivot Table survey
- Complete our Excel Pivot Table survey for a chance to win $50 of Amazon gift certificates
- How do I stop Excel from resetting my custom number format when I update my Pivot Table?
- Excel Tutorial: How to use VBA to delete filtered rows (fast!!) … but not delete hidden rows