Sorting all columns in one step

[Mic1979]

Dear all,

I have a table with many columns, and I need to sort them. Target is for me to speed up the grouping step, and I read some resoucres in the web that Grouping can be faster if the data are pre-sorted.

Coming back to the sorting, is there a way to make it in one step intead of making it for each column?

What I did on sample file is this one:

#"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Region", Order.Ascending}, {"Port_Type_1_2", Order.Ascending}})

I was thinking of  using the following:

Headers = Table.ColumnNames(StuffingBoxChange2),
HeadersToRemove = List.Combine({{"Y3"},{"OEM_Y3_Volumes"},{"DISTRIBUTOR_Y3_Volumes"}}),
HeaderDifference = List.Difference(Headers,HeadersToRemove),

and at the end using HeaderDifference to select the column to sort.

Could you support?

Thanks.

[slorin · Accepted solution]

Hi @Mic1979 

#"Sorted Rows" = Table.Sort(#"Removed Columns", List.Transform(HeaderDifference, each {_, Order.Ascending}))

 Stéphane

[Mic1979]

Thanks!