I need to sort 9 columns
It's possible if you insert a new column and for each row enter a
formula that concatenates all of the 9 columns into a single column.
For instance:
=a1&b1&c1&d1 etc
The result is a long text string. Sorting on that column is the same
as sorting on all 9 columns.
|