Merge Multiple Sheets into One in Excel πŸ“Š

Learn how to consolidate data from multiple sheets into a single sheet in Excel easily.

Merge Multiple Sheets into One in Excel πŸ“Š
Chester Tugwell
277.7K views β€’ Feb 6, 2023
Merge Multiple Sheets into One in Excel πŸ“Š

About this video

πŸ‘πŸ‘If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! πŸ‘πŸ‘
Download the featured file 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 across multiple worksheets in one sheet or table. I use Power Query to achieve this.

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
------------------------

Video Information

Views

277.7K

Likes

1.9K

Duration

6:29

Published

Feb 6, 2023

User Reviews

4.3
(55)
Rate:

Related Trending Topics

LIVE TRENDS

Related trending topics. Click any trend to explore more videos.