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: ExcelPowerQueryFeatures