Is there a way to completely separate a column into a new query?

[phillgrey]

i want to make an custom sort order for an excel file. But the excel file has multiple columns which I want to order. So I want to apply the custom sort order on multiple columns but they are all attached.. Is this possible? Or should all the columns which I want to custom sort be separated from each other. Hope this is understandable

This is my custom sort

As you can see, multiple columns have these values. But in the visualisation I want to sort them by my custom sort.

Can I just merge the 2 and select all the columns? Followed by adjusting the sort order of each column to the custom sort?

i think the problem is that these columns are all connected to each other, making it impossible to custom sort them all separate, but I could be wrong.

[RayWu · Accepted solution]

@phillgrey 

right click -> drill down as new query. For sorting, in the power query editor the order you click sort is the order they are sorted by, like SQL If it does not work, it's possible you're getting syntax error by powerquery and need to double check the formula again. There are other ways to to sort e.g., you can set sort order in the model, but there might be more.