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.
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?
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.
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
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!
out of all the youtube videos on this problem i watched, this was the one that worked. Magaling!
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.
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!!!
I was so lost before. I appreciate this video.
Brilliant! Smooth Execution. Thank you
Thank you so much. This was really helpful
Hay salamat nakahanap din ng videong madaling maintindihan
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
Why you stopped uploading TT Your videos are really easy to understand
In my tab not showing transform data.. only showing edit
What if out of all we have to choose few sheets to combine? Is it possible?
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.
it saves me a lot of time
love it!
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
did you figure it out?
@@krellx4526 unfortunately I didn’t.
😂 been trying to figure it for days 😅
You can use HSTACK formula in excel, but not sure that works in power query
Thank you so much!
salamat idol
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!
Same! I want to use the current file, not create a new one
Too low sound