Forum Discussion
Gangula
8 years agoAdvocate II
Reorder columns based on column headers
I have created a function which renames my columns based on the criteria I need with numbers in all the column headers.
So I need to order these columns based on these numbers in ascending order. See the below code where I manually ordered the columns.
Table.ReorderColumns(RemoveColumns,{"Viewfolder 1", "Viewfolder 2", "View 2", "Viewfolder 3", "View 3"})This is a sample case with just 5 columns, but I have excel files with 100's of columns to order.
I prefer it if "viewfolder" is placed before "view", but it's not mandatory. Is there any way to achieve this using "M"
- Anonymous8 years ago
3 Replies
- jhauff77060Advocate II
You should be able to add a new step in Power Query as follows:
Home > Choose Columns > Select All Columns > Sort A-Z > Name
as shown in the YouTube video Easy Trick for Sorting Columns in Power Query
- AnonymousNot applicable
- GangulaAdvocate IIThank you, that helped.