Advanced fill down scenarios with Power Query

In todays video I will show you two cases on how to fill down when rows have been shifted.

Chapters:
00:00 Intro & Use cases
00:20 Example 1 - Fill down when first row is blank
03:10 Example 2 - Fill down when all values have shifted
Done!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[CAKimberlyLewis]

There totally needs to be more "Tada's" in life! Made me smile ear to ear! Thank you!

[entstuff]

Ruth it is the perfect example of how to extract ghee/butter by bending the finger slightly cross when it is very difficult to extract in straight way. Very clever trick. Thanks for sharing.

[nehalhuda]

Thank You for creating this video with great examples. I was able to learn something new

[decentespresso]

Thank you so much!!! Exports from Quickbooks insert a category on line 1 and then items from row 2 onwards with all cells in line 1 blank after the first row. This has helped enormously in being able to fill down which eluded me for an hour.

[vasanmsv]

Grreat...Thanks a ton for providing this simple but unknown and very helpful solution.

[andresgutierrezquintero]

Just what I was looking for! Thank you so much!

[barttitulaerexcelbart]

thanks Ruth, I like these PQ puzzles. Never saw that : first Unpivot and then pivot : Amazing !! I think that a good data analist really needs a good toolbox, full of tricks to fight the messy data.

[decentmendreams]

Thanks so much for this . The fill down trick helped me a lot when I was cleaning a pdf file. Your topics are very practical and Easy to follow . I always watch your vids. Keep it up.

[oliveroshea]

Excellent Power Query work Ruth, Love it!

[matiasarias]

OMG! That was helpful!
Ruth you killed me with ex.2! Very good.

[anshumansingh]

Hi Ruth.. truly genious ! I was struggling for this on a data set.Thank you so so so much..

[paspuggie]

So simple but brilliant. I would have spent hours trying to work it out lol. Thank you Ruth 😉

[vijaysavarimuthu]

Thanks a lot, I spend a lot of hours on this logic

[dannyhometown]

Amazing query tips, Ruth. I choose option 4: Merge Fiscal into the Date Table. Always keep one calendar table. :P

[Amr-Ibrahim-AI]

Thanks Ruth for these two wonderful query tips

[Iziedking]

Thanks you just gave me some Idea on what am working on

[mariaalcala]

Gracias! Exactamente lo que estaba buscando!!! Gracias gracias!

[kc]

Awesome video... solved my problem at hand! Thank you

[StevenWan]

This is amazing - saved me so much time! suscribed

[EricaDyson]

Wunderbar. Need the first example for sure, so thanks for that. BTW, I think it's number 4 :-)