out of all the youtube videos on this problem i watched, this was the one that worked. Magaling!
@kirkyit
11 ай бұрын
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.
@Melissa.Monique
Жыл бұрын
Thank you!!! I was so lost before. I appreciate this video.
@joragolds3146
4 ай бұрын
Hay salamat nakahanap din ng videong madaling maintindihan
@estephanina
6 ай бұрын
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?
@dipowilliams2252
2 жыл бұрын
Thank you so much. This was really helpful
@EyiBillion
9 ай бұрын
Brilliant! Smooth Execution. Thank you
@fennecfennec5234
3 ай бұрын
your are brilliant million thanks
@djphilter
7 ай бұрын
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?
@successmaharjan2906
2 ай бұрын
Thank u!!! This helpful.
@fisher123fisher
Жыл бұрын
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.
@thierryodou4479
Жыл бұрын
it saves me a lot of time
@harshita9920
9 ай бұрын
What if out of all we have to choose few sheets to combine? Is it possible?
@meher7
Жыл бұрын
Why you stopped uploading TT Your videos are really easy to understand
@mainumd3386
2 ай бұрын
In my tab not showing transform data.. only showing edit
@danielamesser696
11 ай бұрын
love it!
@kaylendao9647
2 жыл бұрын
Thank you so much!
@ydNgAlpha
Жыл бұрын
salamat idol
@pascaljoly5752
Жыл бұрын
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
@krellx4526
7 ай бұрын
did you figure it out?
@pascaljoly5752
7 ай бұрын
@@krellx4526 unfortunately I didn’t.
@krellx4526
7 ай бұрын
😂 been trying to figure it for days 😅
@estephanina
6 ай бұрын
You can use HSTACK formula in excel, but not sure that works in power query
@robertomanuelpaulik4236
Жыл бұрын
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!
@estephanina
6 ай бұрын
Same! I want to use the current file, not create a new one
Пікірлер: 26