Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command

Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command you'll transform nested data into a clean, useable list.
Download the exercise file to follow along...

[ismaelkone]

The tutorial I was looking for! Keep going and thank you

[menoford]

This is exactly the kind of cleanup that I was looking for. Perfect!

[tinaomaivboje]

I have learnt so much from YOU... #Grateful

[ShanAli]

Excellent description but what about if modula dividing value is not fix

[fabrzzo]

Excellent! Brief, concise and so helpful!

[martialazer]

hi Kyle Power Query is powerful. but i have some issue to clean up my data cause im working with Excel 2016. what is the process for 2016. thank you
Azer MARTIAL

[primeplus]

(Relative Versus Absolute Cell References in Formulas) can't play which i have from Udemy Courses
So I need this lesson~~~SIR PLEASE~~ HELP ME