how to sort two columns independently from each other?

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

sorting.xlsx

Workflow

Accepted answers

Qiu

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

0822-xariet.yxmd

All comments

Qiu

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

0822-xariet.yxmd

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.

0822-xariet-r1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703