Power Query - Dynamically Sort Table Columns by user input

In this video i show you how to dynamically change column order based on user input. And if no user input is provided the columns are sorted alphabetically.
#dataanalytics #data #mquery #powerbi #powerquery #excel #exceltips #exceltutorial

Follow along File

Noteworthy techniques
- Using muliple tables to sort and create table headers

Table.ReorderColumns

Table.ColumnNames

[EricHartwigConsulting]

Super awesome video! Thank you creating/sharing this!

[mirrrvelll]

Amazing and smooth trick. Have to note this one in my notepad++ for PQ tricks =) thanks!

[lcorcoran]

Thanks James, Glad you managed to fix your audio problem:)