Sorting Multiple Columns in a Google Spreadsheet
I needed to do this today but the answer eluded me. Here’s how it’s done:
First sort on Column C, then on B, then on A. So actually work backwards from least significant column to most significant. The result will be as you expected. Note this is not limited to just three column, just use the ‘backwards’ order in sorting.
via Google Groups