Take a look at the challenge presented above.  Is it possible to do it in Excel?

Be honest, without Power Query, I have no idea how to do it but manual work. 😁🤦‍♂️

Believe it or not, with Power Query, this challenge can be solved in just a few minutes.

Power Query skills involved:

• Split column by delimited into rows and columns
• Convert date into number
• Add conditional/custom column
• Create a list of number based on two numbers
• Expand list into new rows

Let’s watch it in action in my YouTube Channel:

You may download a Sample File to follow along.

English VO

Cantonese VO

I hope you like this video. If you do, please give a thumb up, share and subscribe. 😉