Forum Discussion

Gangula's avatar
Gangula
Advocate II
8 years ago
Solved

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"