Power Query Challenge by Computergaga - Who eats what (Stacking irregular table) English VO

Note: Cantonese VO is also available here: https://youtu.be/Sp2EU-n1mw0

I came across this Power Query Challenge from Computergaga and I found it really interesting as it seems that it happened to some of my ex-colleagues for event planning before.

I took the challenge. In this post, I will give a possible way of solving it with Power Query. Yes only one of the possible ways.

Here's the original video from Computergaga: https://www.youtube.com/watch?v=yePcEY1ie_o

Here's my blog post:
https://wmfexcel.com/2020/01/18/excel-power-query-solves-a-real-life-problem-who-eats-what/
where you can download a workbook with the solution queries.

Hope you enjoy this video. If you have other suggestion to solve this challenge, please leave your comments.

Видео Power Query Challenge by Computergaga - Who eats what (Stacking irregular table) English VO канала wmfexcel