Відео

Searched high & low & your video finally gave me the answers I was looking for. Thank you so much! 🙏🏽

fellow noobs lol

Hello. how create a multiples columns based on list in excel or dynamics?

Thanks, very helpful!

thank you dito! exactly what i needed! subscribed!

Thank u!!! This helpful.

Hi, very good video, just a question: how do you reconcile the values in the "Items" column with those in the "Needed per Day" column?

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

Super useful and well presented. Thanks!

Should I add the remain codes as I was trying to select different file with same column and format but not refreshing

your are brilliant million thanks

Great video for learning how to use VBA and some Power Query in practice.

The simplest and most straightforward way to rename columns in bulk, and the clearest explanation as well. It works perfectly! Fantastic video! I just subscribed.

Hay salamat nakahanap din ng videong madaling maintindihan

your explanations is clear and layered exactly as per my issue. thank you for sharing your wisdom via this video- it has helped me enormously.

I have corrected the date format but its still not working :(

Finally was able to figure it out thanks to your video

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?

Great!!!! Thank you.

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?

Thank you for these helpful and clear instructions. Everything you showed in this video worked for me. I have an additional question. I believe that because the power query is initially set to a certain folder (in your case Folder A), this linking is set fixed in a way within the query? I am able to select other folders fine. The issue howeever is when I delete the inital set folder, my query doesn't run anymore because it can't find it. Do you know if there is an elegant way to fix this or is this just the way it is?

Absolutely amazing thank you so much This is what I always wanted for my tracker

Great video, thank you! Was stuck on this problem

Hey your video was helpfull but I am getting this error while changing the source. -- Query ‘____’ (step ‘____’) references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Request you to please guide

Still relevant, thank you

Thank you very much. Been searching all over to figure this out. Even chatGPT and Bard :). I'm using this in an outlook email query. I can now write multiple email attachment names to a cell, thanks to you. Is there a way we can add a condition to this formula, like select the attachments.name column if the attachments.inline == false ? To filter out the inline attachments, I have to 1. first extract the attachments column ( a table), 2. then filter out inline:true, 3. then group the table by "ID" 4. Then work your formula in this new grouped table. 5. Combine 2 queries..... If I could get a condition in there, maybe I could save extracting and regrouping.

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

Brilliant! Smooth Execution. Thank you

How do i get data for psei? The composite index of pse. Pls help

I was searching for the same thnaks

wow! massive info, thank you a million times! :)

love it!

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.

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!

Pwede po ba sa google sheets to

thank you so much <3 made my dayyyyy !!!

Thanksss!

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

What to do if the column we want to rename is not present in the table.. how to make this dynamic

Neat, this is exactly what I needed. Thanks so much!

Hey i tried using this solution for users to select more than 1 file, they are the same kind, hence idea is to append them altogether. Challenge am facing is that I cretaed 5 file paths, but user may not use 5 paths all the time. Hence when query is run it breaks due to value being null. Do you know a way to create some sort of conditional?

Fantastic solution 🙏

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

Thank YOU <3

Bravo

Hi, your video was extremely helpful! I am trying to learn how to assign based on a certain task type and also how to load in new tasks to be assigned from a folder as a drop off point.

it saves me a lot of time

salamat idol

supper explanation. We can make do pivoting these results and create headers out of that.

Good