Download the featured files here:

Different headers example: https://www.bluepecantraining.com/wp-content/uploads/2021/10/Pivot-Table-Multiple-Sheets-Different-Headers.xlsx

Same headers example: https://www.bluepecantraining.com/wp-content/uploads/2021/10/Pivot-Table-Multiple-Sheets-Same-Headers.xlsx

In this video I demonstrate how to create a PivotTable based on multiple worksheets in Excel. There are two scenarios where this might be needed:

1) You have related data and the column headers are different on each sheet. In this is the case you will need to add each table to the Data Model and then establish relationships using primary and foreign keys.

2) You have related data and the columns headers are the same on each sheet. In this case you will need to use Power Query to append the sheets together.


Table of Contents:

00:00 - Intro
01:00 - Sheets have different headers
05:08 - Sheets have the same headers
09:24 - Updating (sheets have the same headers)
10:57 - Updating (sheets have different headers)
------------------------