When I sort a column in Google Spreadsheets, the blanks always seem to sink to the bottom. Can I have rows with blank cels be organized first / highest?
Alternatively, is there a function wherein I can specify a sort order based on an array of options, like
[ [1,''], [2,'i'], [3,'x'] ]
1,2,3 is the sort order DESC. the string is the
char to match and associate with that sort order.