Consolidating data from multiple sources


show more Consolidating data from multiple sources provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Consolidating data from multiple sources

Most of the time you will create a Pivot Table from a data list, but you can also summarize multiple data ranges using a Pivot Table if the data is formatted appropriately. To consolidate a series of data ranges into a Pivot Table, the ranges must be laid out in cross tabular format and have exactly the same structure. As an example, consider the worksheets that I have in my Consolidating.xlsx worksheet. On the SupportCalls worksheet, I have data reflecting the number of support calls received in the years 2007, 2008, 2009 and 2010 for the four regions North, South, East and West.

I have the same data for order calls on the OrderCalls worksheet. And I have the same data for return calls for product returns on the ReturnCalls worksheet. Please note that the Region and Year column and row identifiers occur within the same cell. The reason you need to do that when you are consolidating different ranges into a Pivot Table is that the data source must be a perfect rectangle. In other words, if ...

Consolidating data from multiple sources
Video duration: 3m 53s 1h 7m Intermediate

Viewers:

Consolidating data from multiple sources provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...