Reorder columns based on column headers

[Gangula]

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"

[jhauff77060]

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 

[Anonymous · Accepted solution]

@Gangula,

This post should have the solution you are looking for. 

[Gangula]

Thank you, that helped.