'Excel BYROW sort result

I have got the following data:

Initial data

I have filtered the data to remove 0 values using the following:

=FILTER(AE11:AF33,BYROW(AF11:AF33,LAMBDA(a,SUM(a)))>0)

I can't for the life of me sort this filter, my current output is:

Current output

But the output I want to achieve is:

Desired output

Any help on sorting this filter would be greatly appreciated!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source