HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Convert a Pivot Table to a Standard List

281,198 views November 13, 2011 8:29

Watch on YouTube
ChannelDanny Rocks

Description from the creator

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 - 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

About this tutorial

Danny Rocks published this 8:29 video tutorial on November 13, 2011. It has been watched 281,198 times on YouTube.

Category
Education
Duration
8:29
Published
November 13, 2011
Views
281,198
Likes
1,393

Tags

Share

This tutorial in other languages