Excel Power Query - Combine Data from MULTIPLE Excel Files into ONE (FAST!)
How do you Combine Data from Multiple Excel Files into 1 File?
Copy the data from the first file and paste...
Copy the data from the second file and paste...
Copy... paste...
Copy... paste...
A new file comes in, what do you do?
Copy and paste.
Another file comes in again, what do you do?
Copy and paste...
That's what I do in the past! Don't do that!
Now, I use Power Query, it's much faster and automatic and results in less errors!
Combine 100 Excel files? No problem!
Add Excel files? No problem!
Also, I have a special trick for you - What if the Sheet Name for each Excel file is different?
Watch the video to find out more. Enjoy!
Comment below if you are using this shortcut or trick!