Sorting column values in a specific order

1

Hi,

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
R

2

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.

3

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

4

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.

Best,
R

5

You’re welcome! :slight_smile:

1 Like