top of page

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

28 views0 comments

Recent Posts

See All

Check out the video below on how to create Dynamic, Cascading Drop-Down Menus in a Microsoft Excel list. This method of creating Dynamic Drop-Down Menus uses the built-in Data Validation list tool, Na

bottom of page