Uploaded April 2024 | Updated September 2026, 2 weeks ago
Create a Pivot Table from Multiple in Sheets in Excel. Are you struggling to consolidate data from different spreadsheets? Want to simplify your data analysis and reporting? You've come to the right place! In this video, I’ll show you the fastest method to create a pivot table in Excel using data from multiple sheets, with the help of the powerful Power Query Editor. This guide is perfect for Excel users of all skill levels looking to enhance their data management capabilities.
Download practice file: https://go.teachers.tech/pivottable_multiple_sheets
I0:00 Introduction
0:56 Create tables
2:03 Launch Power Query Editor and add source
3:13 Merge data into one query
4:50 Close and load to Pivot Table
7:16 Build relationship between tables
Create a Pivot Table from Multiple in Sheets in Excel. Are you struggling to consolidate data from different spreadsheets? Want to simplify your data analysis and reporting? You've come to the right place! In this video, I’ll show you the fastest method to create a pivot table in Excel using data from multiple sheets, with the help of the powerful Power Query Editor. This guide is perfect for Excel users of all skill levels looking to enhance their data management capabilities.
Download practice file: https://go.teachers.tech/pivottable_multiple_sheets
I0:00 Introduction
0:56 Create tables
2:03 Launch Power Query Editor and add source
3:13 Merge data into one query
4:50 Close and load to Pivot Table
7:16 Build relationship between tables
