Sorting column values in a specific order


I am trying to sort a column from Z to A, in a specific order.

This column contains blanks (just this column, it has data in corresponding columns); numeric values as well as alphanumeric values.

I want to sort this column in a way that ensures that the alphanumeric values are on top, followed by numeric values and then blanks.

Can anyone please help?

Thank you

The default sort order in EasyMorph is as follows:

  • Numbers
  • Text (alphanumerics)
  • Booleans
  • Empty cells and errors

Which is not the order you need.

I would suggest moving rows with blanks into a derived table, then sorting the remaining rows in descending order (this will put alphanumerics on top of numbers), then appending the rows with blanks at the bottom.

Ah I see. Okay I will try that. Thank you so much :slight_smile:

Hi again,

It worked perfectly, thank you so much for such prompt response :smiley:

Although I had to create 3 separate derived tables - one each for blanks, numbers and alphanumeric values and then append them together. It worked nonetheless so thanks a lot.


You’re welcome! :slight_smile:

1 Like