I really like Power Query (in both Excel and Power BI). Honestly I do not know much about the M behind the scene (still learning it piece by piece). Nevertheless, I’ve got the POWER simply through the User Interface of Power Query Editor. Seriously, everyone can become a data wizard by using Power Query! Let’s watch the following two videos to feel the POWER of Power Query.
Here’s is a challenge (with solution) from Mr Excel on how to reshape data.
You may download a sample workbook from Mr.Excel YouTube channel to follow along.
And here’s my approach to solve the challenge:
If you prefer reading to watching, please continue to read this post.
Note: All screenshots used in this post are captured using Excel for Office 365. If you are using other versions of Excel, you may find the locations and look&feel of buttons a bit different. The concept is the same though.