how to sort two columns independently from each other?

[xariet]

Hi All!

I have two columns which I need to sort independently from each other, sort (group) by part # first and then assign Category in the alphabetical order and Null values at the bottom, not at the top as Alteryx does with the sorting tool

Thanks for your help

OUTPUT
part#        Category

35648             A
35648            B
35648             C  

35648             D
35648           Null
35648           Null
13427865     A
13427865     D
13427865     E
43900         B

[Qiu · Accepted solution]

@xariet 
This is exactly the Sorting tool can do, if I am not mistaken.

[Biswarun]

To add to @Qiu's solution, please be careful about the order of the fields in the sort tool. That's important!

[xariet]

Thank you @Qiu . Is there a way if I have Null values in the Category to put them at the bottom? when I am sorting Ascending all Null values come at the top. I have updated my question.

[xariet]

Thank you @Biswarun 

Is there a way if I have Null values in the Category to put them at the bottom? when I am sorting Ascending all Null values come at the top. I have updated my question.

[Qiu]

@xariet 
We can add a SN for null to be 1 and other to be zero as below.