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...
- 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!
Wow- this is a game changer. Thanks so much !!
sevenhills
Super User
Super UserDynamically Reordering Columns
1. How to get the current table column names
2. 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!
Wow- this is a game changer. Thanks so much !!
- sevenhills
Thank you. Do me a favor by marking my reply as solution. (with Kudos - thumbs up icon). Appreciated.