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
github.com/jbo...
Noteworthy techniques
- Using muliple tables to sort and create table headers
Table.ReorderColumns
powerquery.how...
Table.ColumnNames
powerquery.how...

[@mirrrvelll5164]

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

[@kebincui]

Excellent as always. Thanks James

[@EricHartwigExcelConsulting]

Super awesome video! Thank you creating/sharing this!

[@lcorcoran56]

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

[@basensei8699]

thanks for pointing it out last time! my new mic setup was incorrect! :)

[@qasimawan3569]

This is awesome, thanks James!

[@basensei8699]

Glad you liked it!