Reverse Column Order

[Faronnj]

Goodmorning Alteryx Community,

I have the following data:

Sphere	Count
< -18	21
-15 to -18	21
-12 to -15	34
-9 to -12	32
> -9	7

I want to do a simple reversing the order to make the following table:

Sphere	Count
< -18	21
-15 to -18	21
-12 to -15	34
-9 to -12	32
> -9	7

I tried the sort function but it doesnt work with the > and < signs in there.  I need to reorganize this for the bar graph I am trying to create.  Is there another work around?  Workflows always always appreciated and loved.

Thank you as always in advance,

Nick 

[afv2688 · Accepted solution]

Hello @Faronnj ,

You could add a recordID and use the sort on it to reverse it 🙂

Regards

[Jonathan-Sherman · Accepted solution]

Hi @Faronnj,

As you asked so nicely workflow is attached! But i would suggest and have used the exact method @afv2688 did.

Regards,

Jonathan

[Faronnj]

Thank you so much guys!  I know asking for the workflows is tedious, but I save them all in a folder to reference when I run into similar problems.

Nick