Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

sort column according to another

I want to sort column1 by the numbering of column2 and I get the following error How could I solve it? Column1 Column2 albert 1 albert 1 juan 3 manuel 4 thank you.
AngeloParana's avatar
AngeloParana
Icon for Resolver I rankResolver I
2 years ago

You can initially make the column 1 as distinct first in PowerQuery then load. You can now sort the column1 by column 2. After that back to Powerquery then remove the step that make the column1 distinct and apply. Sorting still applies

 

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    I try to sort having modified the values in the description column but I keep getting an error, I can't find the why.

    Thank you.