Pivot Table Tutorial: How to flatten a cross tab table

Youtube video: Flatten crosstab table using pivot table in Excel

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!

Victor Chan
Hi I'm Victor. I started Launch Excel to help you use Excel and VBA faster. Thousands of people have learned new skills and increased their effectiveness at work with our help. You can do it too! Also I've personally used Excel lots since 2002. I use it mainly in accounting and finance but I also have a Masters degree in Engineering from Cambridge University. I hope you enjoy the site and tutorials!
Join over 9,000 subscribers

GET BETTER AT EXCEL

Recommended Posts
Contact Us

Please send us an email and we'll get back to you, asap.

Not readable? Change text.