• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Importing Data: An Overview > Importing Data to Pivot Tables

Importing Data to Pivot Tables

If you've worked much with Excel's pivot tables, you're surely familiar with a list as a pivot table's data source. And you could use the data as shown in Figure 4.23 as a pivot table source, without any further manipulation.

Refer to Figure 4.15, which shows the Import Data window, which appears when you're through defining a query with Microsoft Query or with the Query Wizard. You'll notice in that window there's an option to create a pivot table report (the exact wording depends on the version of Excel that you're using). If you select this option, you see the final step in the Pivot Table Wizard instead of the external data range with its records and fields.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint