Skip to Main Content
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
book

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

by Thomas Fragale
May 2024
Beginner to intermediate content levelBeginner to intermediate
304 pages
7h 43m
English
Wiley
Content preview from Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

CHAPTER 7Creating a Pivot Table from Multiple Spreadsheets

So far, all the pivot tables used in this book have come from one list of data, and in many cases, that is typical. But there will be times when different sheets have similar data or related data, so you will want to create the pivot table from multiple sheets or from multiple ranges within the same sheet. In this chapter, you will explore two different ways to generate a pivot table from more than one list of data. First, you will learn how to make a pivot table from lists that are similar to each other. Then, you will learn how to make a pivot table from lists that have different types of data but share a common field.

A picture depicts Q R code.

Creating a Pivot Table from Multiple Ranges Using the PivotTable Wizard

Let's say you have multiple sheets or multiple ranges on the same sheet that are structured in a similar way. Maybe the data on each sheet is a budget for each month, or for each district, for example. You may want to add these sheets together to get totals for a certain time period, for a region, or for something similar. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Bill Jelen

Publisher Resources

ISBN: 9781394243051Purchase Link