How to Consolidate Multi-Source Data in Excel 2010


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

Consolidating data from multiple sources

Most of the time you'll create a PivotTable from a data list or Excel table. But you can also summarize multiple data ranges using a PivotTable, if the data is formatted appropriately. To consolidate a series of data ranges into a PivotTable the ranges must be laid out in cross tabular format and have exactly the same structures. In a sample file here, I have three worksheets: SupportCalls, OrderCalls, and ReturnCalls. And the data on the SupportCalls worksheet has a series of distribution regions, North, South, East and West, along the Row Label area and then the Years 2007, 2008, 2009 and 2010 along the top, providing the values for the Column Labels.

And then here in cell B3 you'll see that I have Region-Year. Now, normally if you were to create a cross-tabular table like this, you would put Region in cell B3 and Year in cell C2. The reason you don't do that in this case is because this region that contains the data and all of the labels must be perfectly rectangular. In othe...

Consolidating data from multiple sources
Video duration: 4m 37s 3h 43m Intermediate

Viewers:

Consolidating data from multiple sources provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

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