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!
- How do I stop Excel from resetting my custom number format when I update my Pivot Table?
- Working with Data in Excel Part 1: 10 Excel Data Entry Tips Everyone Should Know
- Working with Data in Excel Part 2: Fine Techniques for Excel Lists, Drop Downs and Data Validation
- 15 Awesome Resources for Excel Shortcuts