http://www.wikihow.com/Sort-by-Multiple-Columns-in-Google-Spreadsheets
Google Spreadsheets are an effective way to store and manage data, and have many of the capabilities of popular spreadsheet applications like Microsoft Excel. In addition, Google Spreadsheets make it easy to collaborate with others on the the same documents. Despite their power and flexibility, it's not always intuitive for Excel users to figure out how to do some basic tasks in Google Spreadsheets, such as sorting by multiple columns. Unlike Excel, you can only sort by a single column at a time; this limitation requires you to take a different approach to sorting if you want to organize by multiple columns. Read on to learn how.
Input your data in your spreadsheet.
Decide what order you'd like to sort your information. For the purposes of this example, assume we want to to have the people in the list grouped by city, then last name, then first name.
Sort by the least important, smallest or most narrow grouping in your sort order. In this case, that would be the column with first names. Click on "sort range" then choose if "A-Z" or "Z-A" and press "Sort"
Sort by the next grouping in your sort order. In this case, that would be the column with last names.
Continue sorting by increasingly larger or more important groups in your sort order until you have the list organized as you would like.
