Cannot sort blanks to bottom of table

[Blue Max]

We are unable to properly perform and ascending sort (A-Z) when a table has
blank cells in the sort column. The resulting table, after sorting A-Z,
places all the rows with blanks in the sort column at the top of the table
instead of at the bottom. How can we get the data to sort to the top of a
table (using the drop-down menu for that column) with the rows (with a blank
cell in the sort column) at the bottom, versus the top, of the list?

We have tried filtering the blanks, but this hides rows which then obscure
data we need to display to the right of the tables. As of today, we have
yet to locate an option that would allow us to force rows with a blank sort
cell at the bottom of the list versus the top. Obviously, we want our rows
with data at the top of the table and the blank rows at the bottom. How can
we force the blank rows to the bottom in an ascending (A-Z) table sort?

 

[Ron@Buy]

Try sorting Z-A then only select the cells in the sort column above the blank
cells and sort again A-Z. this will leave the blank cells at the bottom.
Hope this helps

 

[Blue Max]

Thank you, Ron. I have tried that before and it works if you want to
perform a manual sort each time. However, this information is in a table
and we like the convenience of simply selecting the button at the top of the
column to select an A-Z sort. The down side, however, is that the natural
sort order places the blanks at the top of the table instead of the bottom,
which seems quite illogical for most presentations.

We have also noted that for a table, the user can create a custom sort order
(which most oddly is found under the feature to sort by color).
Unfortunately, we must not understand the proper syntax, because we cannot
get zeros, blanks, or certain special characters to sort to the end of an
alphabetical sort, even if they are specified at the end of a custom sort
list. In fact, we are not even sure how to specify an alphabetical sort
prior to special characters at the end, except that listing A-Z seems to
address the alphabetical aspect. Any ideas?

Thanks,
Richard
************