Connect Power Query to a Dynamic Dropdown List

Can Excel’s Power Query (Get and Transform) be used as contents for a dropdown list in Excel? And what would be a good use for it?

That came across my mind recently and this video is the result of that inquiry. You’ll see COUNTIFS, Dropdown boxes, Fill-Down, and everything!

For an intro to Get & Transform (Power Query) try my course:

My book: Guerrilla Data Analysis 2nd Edition
My old blog: