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

Chapter 27. Using the Power of Pivot Tab... > Consolidating Data Using a Pivot Tab...

Consolidating Data Using a Pivot Table

Often, the data you want to summarize is located in more than one range—sometimes even in several different worksheets. If the ranges have a similar structure and common row and column labels, you can group them together for analysis in a single pivot table.

See Consolidating Worksheets


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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