O'Reilly logo

Pivot Table Data Crunching by Michael Alexander, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8. Using Disparate Data Sources for Your Pivot Table

In this Chapter

Working with Disparate Data Sources 141

Using Multiple Consolidation Ranges 142

The Anatomy of a Multiple Consolidation Range Pivot Table 146

Creating a Pivot Table from an Existing Pivot Table 151

Working with Disparate Data Sources

Until this point, you have been working with one local table located in the worksheet within which you are operating. Indeed, it would be wonderful if every dataset you came across were neatly packed in one easy-to-use Excel table. Unfortunately, the business of data analysis does not always work out that way.

The reality is that some of the data you will encounter will come from disparate data sources—meaning sets of data that are from separate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required