Sign up for our Excel webinar, times added weekly: [ Ссылка ]
In this video, I explain how to combine multiple Excel Tables or Worksheets with Power Query. You will learn how to fully automate this process to save you a ton of time with this common Excel task.

The video covers:
The prerequisites for the data and column structure.
How to setup the connection queries in Power Query, plus a macro to make this faster.
How to append or combine the queries to stack the data.
The update and refresh process when the data changes or you get new data.
How to add new tables to the append query.

You can download the example file on the following page:

[ Ссылка ]

Additional Videos & Resources:

Excel Tables for Beginners: [ Ссылка ]

Power Query Overview: [ Ссылка ]

How to Install Power Query:[ Ссылка ]

Introduction to Pivot Tables & Dashboards Video Series: [ Ссылка ]

Free Webinar on The Modern Excel Power Tools:

If you are new to Power Query and/or not sure how it fits into other features like Power Pivot, Power BI, pivot tables, or macros & VBA, then check out my free training webinar. It’s called the Modern Excel Blueprint and it’s running right now for a limited time.

[ Ссылка ]
00:00 Introduction
01:58 Power Query Setup
06:58 Updating and Refreshing Data

свернуть