Thank you for this clear demonstration - your method is much more efficient than the more complicated solution i came up with. And your explanation is easy to follow. Thank you for sharing your expertise.

out of all the youtube videos on this problem i watched, this was the one that worked. Magaling!

Thank you!!! I was so lost before. I appreciate this video.

Hay salamat nakahanap din ng videong madaling maintindihan

Thank you so much. This was really helpful

Brilliant! Smooth Execution. Thank you

This doesn't work if the columns are in a different order. A function would but I can't figure out how to get PQ to do the auto steps and generate a function for sheets the way it does for files.

Question: for Get Data, will it work to select the same workbook as the data source? Does PQ require making a new workbook as in your example?

Thank you so much!

Thank u!!! This helpful.

How do you combine multiple Queries, the section on the left of the Power Query Editor, into one and or how do you combine multiple worksheets that each query makes when I click on close and load; all into one worksheet?

your are brilliant million thanks

it saves me a lot of time

Why you stopped uploading TT Your videos are really easy to understand

love it!

What if out of all we have to choose few sheets to combine? Is it possible?

salamat idol

In my tab not showing transform data.. only showing edit

Is it possible to combine the sheets not one below the next but instead to the right of each other? I tried to transpose but it gave me something weird? Same when using unpivot, which I don’t understand

Too low sound

still no really usefull cause u must create another file to do that. somes enterprises dislike create another file. Do u find any way to don't create another file? ty!