Power Query: Pivot (pivot column) - student question analysis
The other day, a student who had recently started taking the "Developing Power Query" course approached me with a question.
After taking just a few basic lessons, Mikhail wanted to immediately apply the knowledge he had gained in real practice, and he solved his work problem without having a more or less sufficient set of Power Query tools. Mikhail asked me to evaluate his solution for correctness and optimality.
In this video, with Mikhail's permission, I will demonstrate and explain:
his solution
a more optimal solution
I will briefly tell you about the existence of the most optimal solution
Source file here: https://yadi.sk/d/wpREPPWSd27bOw
The optimal solution here: https://yadi.sk/i/bgSEXP65eFf1mg
A pleasant bonus awaits those who want to master Power Query to a professional level.
Sign up for the course "Developing Power Query Queries in Excel (with M language learning)": https://clck.ru/RJXKY
Sign up for the trial course "Basics of Power Query": https://clck.ru/RESZR