How to Convert a Pivot Table to a Standard List
I created this video in response to a viewer who has a boss and a client who:
1) Do not know how to use Pivot Tables
2) Do not want to learn how to use Pivot Tables
She has been asked to create a summary of sales by Year a Quarter of the year - a report that is easy to create with a Pivot Table!
However, now she needs to convert the Pivot Table into a standard Excel List so that her boss and her client can Filter it and Subtotal the list.
Don't laugh - this is NOT an uncommon request. Watch as I demonstrate each step:
First to create the Pivot Table Report.
Then to Convert it into a List - including "filling in the blanks!
I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to take advantage of the many resources that I offer.
Danny Rocks
The Company Rocks