Power Query Table Flip Challenge

Here's my solution to our November 2021 Power Query Challenge

If you'd like to have a go before (or after) watching my approach then you can download the file from our blog here...

Feel free to send us your approach and we'll add it to the blog page (unless you would prefer us not to).

Connect with me

Sign up for our newsletter to get advance notice of the future challenges...

[seanwood]

I’m just starting out and have not only found this video extremely helpful but am now going down a rabbit hole with ALL your videos. Huge thank you.

[ensysconsultores]

The transpose step in the beginning is key in this type of challenge. I loved the way you referenced the series of steps. Pretty clever and shows empathy for your future self.

[EricaDyson]

Well that was excellent. The marker to show the start and end of a series of steps was completely new to me and your explanations of pivoting (when to and what) were spot on. Mega thanks. Keep 'em coming.

[IvanDub]

I've learned so much from this challenge. Thanks for posting this!! ... so cool)

[GeertDelmulle]

Classic way of solving this. In 2018 I had this problem with a twist: the so-called headers were way too long to be actual headers.
Some people make very bad data tables. :-)

[JonathanExcels]

I would suggest editing your formulas instead of renaming columns that were just created. The transformation to end of month is a new trick. Thank you.

[learnpowerbi]

Again Wyn, thanks a lot. These genius steps save my time a lot.

[flowerpixel]

This is such a good example. I can easily do 1 header but not 2. I learn a lot more doing challenges

[sedarathnadcd]

Wonderful illustration for data cleaning. I learn much from your videos and now doing exercises. Thank you for sharing these types of data-clearing exercises.

[malejandrahorvath]

That's why I'm a big fan! This is very useful. Thank you Wyn! 😊

[DiptaGhossan]

exacrly what i am looking for. Been trying to work it out the whole day and still couldnt think of a way. This is VERY HELPFULL. THANK YOU SO MUCH

[HandyPaladin]

The thing I am most commonly learning from these videos is that I over complicate queries and there are built-in functions I've somehow never looked at.

[brunof.s.]

I wish I had seen this 2 years ago. I had tons of data structured just like that and didn't have the catch of using transpose as initial approach.

I wasn't aware that you also could put emojis on your step names, nice 🙂👍

[wayneedmondson]

Hi Wyn. An awesome challenge! My solution was very similar. A great learning experience! Thanks for sharing your approach and the practice file. Much appreciated :)) Thumbs up!!

[AgulloBernat]

good! I realize I barely use right click on cells and columns and there's lot's of good stuff in there. Filtering out values! so convenient!! I also separate the first two rows to fix them, but I see there's really no need for that. I love seeing you powerquery'ng

[iankr]

Great tricks and techniques, Wyn. That pesky Change Type step that Power Query frequently smuggles in sometimes catches me out, too!
Many thanks

[sherlock]

It's so useful! Thanks a lot mate!

[paspuggie]

Love the tip to separate your Applied Steps using the icons. Smart...one for me to use in anger ;)

[kebincui]

Great. Thanks Wyn for sharing👍🌹 Please kindly explain why you first named the data section as a range rather than a table?

[andrewferguson]

Late to the party, but loved following along, though Pivot and Unpivot confuses me.