Consolidate & Clean Multiple Excel Sheets in One Pivot Table

Check Out the Complete Excel Power Query course:
*** Note: On XelPlus you will get additional bonuses that are NOT available on any other platform! Check the course landing page for more info.

Excel’s Power Query can easily solve a common problem in Excel: Consolidating information from multiple Excel worksheets into one Pivot Table. This also works if you’d like to append data from multiple sheets into a single Excel table.

In this video we’ll combine the data from multiple Excel sheets into a single Pivot table in the same workbook. And we’ll do it in a dynamic way so that when new sheets are added, we just need to press Refresh on our report. We will also apply Power Query’s convenient transformations to clean and prepare the data for our report (fill up empty cells in a table)

⯆ DOWNLOAD the workbook here (scroll to the bottom of the blog post):

Power Query Playlist:

★ My Online Excel Courses ►

✉ Not sure which of my Excel courses fits best for you? Take the quiz:


Get Microsoft 365:
Microsoft Surface:

Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:

More resources on my Amazon page:

Time Stamps:
00:00 Combine Data from Multiple Sheets in one PivotTable
01:48 Send data to Power Query
02:25 Send data from all sheets in one go
03:45 Apply Power Query’s Data Transformations
04:58 Create Excel Pivot Table on Appended Data
05:38 Exclude End-Report as Data Source in Power Query
07:46 Refresh Report with New Data

Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #powerquery

Tag: consolidate excel, XelplusVis, Leila Gharani, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, Microsoft Excel tutorials, Microsoft Excel, Excel 2016, Excel 2019, XelPlus, Microsoft 365, Excel 365, power query, excel power query, excel consolidate data, excel consolidate data from sheets, Excel merge data multiple sheets, combine multiple excel sheets into one, combine data in excel, combine sheets in a workbook, excel get and transform, excel append data

Xem thêm:


Bài viết liên quan

33 Bình luận. Leave new

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Fill out this field
Fill out this field
Vui lòng nhập địa chỉ email hợp lệ.
You need to agree with the terms to proceed


Xem nhiều nhất