This is an update to a previous video ([ Ссылка ]) after a few great suggestions from:
@Dan_De_Man and @baskis69
How to consolidate multiple Excel files when the sheet names are different.
Power Query From Folder is very powerful and even more flexible with these 2 techniques.
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. [ Ссылка ]
Did you know I've written a book "Power BI for the Excel Analyst"?
[ Ссылка ]
Connect with me
[ Ссылка ]
![](https://i.ytimg.com/vi/BVhziaHBvS4/maxresdefault.jpg)