Create an Updating Dropdown List with Power Query

This video will show you how to create a dynamic drop down list from a table that gets transformed in Power Query. The output table become a source for a drop down list using the Data Validation feature in Excel. You can then hide the output table because maybe you don't want users to mess with it. This is a simple example, but it can be applied to more complex situations.