Combine data from multiple sheets into a single sheet in Excel Consolidate tables into a single sheet

Download the file shown here: https://www.bluepecantraining.com/wp-content/uploads/2023/01/Combine-Multiple-Sheets-into-One.xlsx

In this Microsoft Excel tutorial, I explain how to combine data stored on multiple worksheets into a single sheet or table. I use Power Query to achieve this.

Contents:

00:00 – Presentation
00:14 – Combine sheets (tables) in the same workbook
00:21 – House data in an Excel table
00:47 – Create a query that returns all tables
01:37 – Change the formats of certain columns
02:11 – Load query in Excel
02:32 – Modify the query so that it does not include the consolidated table
03:30 – Add a new sheet and refresh the query
04:30 – Consolidate data into a separate workbook
——————–

Please take the opportunity to connect and share this video with your friends and family if you find it useful.