Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Sorting all columns in one step

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 a...
Need Help
  • slorin's avatar
    slorin
    1 year ago

    Hi Mic1979 

     

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

     Stéphane

slorin's avatar
slorin
Super User
1 year ago

Hi Mic1979 

 

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

 Stéphane

  • Mic1979's avatar
    Mic1979
    Post Partisan
    1 year ago

    Thanks!