Power Query - Combine Excel files with different sheet names

How to consolidate multiple Excel files when the sheet names are different.

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[premnapichp.]

Video was easy to follow and really clear. THANK YOU SOOO MUCH!!! 🥺

[mcwahaab]

Quick and easy. Thank you Wyn. Can we also try to combine a disorganized, messy data with different column headers and headers with spaces

[antootje]

Thank you so much! This was exactly what I was looking for! A short, straight to the point video with perfect explanation.
Also gave me more insights in the possibilities of Excel. Thanx!

[pOle]

You've been helping me since last year! thanks a

[arnaudmanir]

A thousand times thanks, this helped immensely.

[garyknott]

Just what I needed, fantastic, many thanks Wyn! ⭐⭐⭐⭐⭐

[hbokam]

Sick Trick! Loved how simple you made it.

[baskis]

Nice trick .... I usually change the navigation step. {[Item="name", to .... to prevent user creativity. :)

[Dan_De_Man]

Great concise video although In the custom column formula is it better to add, true so headers get promoted there or doesn't it matter. As I saw a different video where they added, true

[emanuelecostantinocatanzar]

Nice trick, thank you 🙂Is there a way to keep the name of the source file in the output table?

[alvarogomez]

Thanks! This was bugging me. QQ, can i get in column A the source file name as a normal combination query does?

[andyba]

What if the worksheet has multiple tabs, the sheets i'm working from have 2 tabs i.e. 'month + graph' and 'month +data. I'd only want the data one

[scottwilson]

My combine files button is greyed out after your last step, any ideas?

[muzniahamed]

Hi sir,
I am from Sri Lanka
I have a question about power query
"HOW TO REDUCE THE LODING TIME IN POWER QUERY"
Please reply...
I am facing big issue in power query