EASY Trick to COMBINE Multiple Excel files into ONE with Power Query
Channel: Essential Excel
Date: 2022-02-23

Support Me & More: linktr.ee/benthompsonuk

How to combine the content of all files within a folder!

In this video we demonstrate how to quickly combine the data from multiple files into a single data set using Power Query... so no more manually copying to a master file!

Why would you want to combine data from multiple files? The particular scenario we look at is combining monthly data such as time stamped reports and the benefit of combining into one data set gives us the ability to visualise that data.

In this example we use Power Query within Excel, but the content in this video is the same and transferable to other applications that use Power Query such as Microsoft Power BI.

If you are new to the channel or watched out videos before, please consider subscribing and if you enjoy the video don't forget to give it a like!

Instructor Lead Excel Course ► https://essentialexceluk.com/products/master-excel-course

More Tutorials ► https://essentialexceluk.com/blogs/tutorials

#powerquery #combine #tutorial #merge