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.
I hope you like this video. If you do, please give a thumb up, share and subscribe. 😉