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