Forum Discussion
Reordering many columns in power query
Hi,
I have about 10 queries with about 25- 30 columns each where I need to have a custom order on these. Dragging and dropping things in power query doesn't seem very efficient and the videos that I have seen don't seem practical for large data sets.
Are there any ways to dnyamically change the column order on a large scale?
Thanks
- Dynamically Reordering Columns1. How to get the current table column names2. Build a list of your column names for each table; i.e., one list per each table.If you dont want the list, that is fine too. Code the list of desired column names of your interest and use directly in Table.ReorderColumns.3. You can use Table.ReorderColumns along with MissingField.Ignore.Details and steps are described in this article:Pretty easy after you do the first table.Hope it helps!
3 Replies
sevenhillsSuper User
Dynamically Reordering Columns1. How to get the current table column names2. Build a list of your column names for each table; i.e., one list per each table.If you dont want the list, that is fine too. Code the list of desired column names of your interest and use directly in Table.ReorderColumns.3. You can use Table.ReorderColumns along with MissingField.Ignore.Details and steps are described in this article:Pretty easy after you do the first table.Hope it helps!- sevenhills
Thank you. Do me a favor by marking my reply as solution. (with Kudos - thumbs up icon). Appreciated.