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

• #education
• #excel_pivot_tables
• #group_field_by_month
• #quarter_and_year
• #copy_pivot_table
• #convert_pivot_table_to_a_list
• #software_tutorial
• #computer_software
• #educational