Pivot Table Tutorial: How to flatten a cross tab table
Last updated on September 29, 2011 By Victor Chan
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!
Related Posts:
- 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
Author: Victor Chan
Victor expertly teaches Microsoft Excel to people all over the world. He has millions of views of his popular Excel explainer videos on YouTube. These show time-saving shortcuts and real-world applications explained with easy-to-follow visuals.
Victor has over 20 years of experience using Excel as a professional for Big 4 Audit Firm Deloitte and two global tech companies. He knows firsthand that being more productive with Excel can lead to greater job satisfaction and career growth.
Recommended Posts
Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.
Solve tricky Excel problems and take your work to the next level! Get customized solutions for your unique needs. Save time and gain insights with truly expert Excel solutions from only $97 per task.
Get a clear overview of your project progress using the Excel project timeline. Use it to communicate the big picture, track task progress, and stay on top of your project goals. Stay organized with our project timeline!
Our cheat sheets provide quick and easy reference to commonly used Excel VBA concepts and code snippets.
Unlock new levels of productivity and efficiency with our cheat sheets, and write VBA code like a pro in no time.
RECOMMENDED READING
Are you looking to upskill and stay ahead of the curve? Excel is a powerful tool that keeps growing in demand. We round up the best online courses for learning Excel.
Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!
Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.