In this Microsoft Excel tutorial I explain how to combine data stored across multiple worksheets in one sheet or table. I use Power Query to achieve this.
Click here to download the featured file.
Video Table of Contents
00:00 – Introduction
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 – Modify formats for some columns
02:11 – Load the query to Excel
02:32 – Modify the query so it does not include the consolidated table
03:30 – Add a new sheet and refresh the query
04:30 – Consolidate data in a separate workbook