This is a short but very helpful tip. In order to sort on multiple columns in a view:
1. Click on the first column header
2. Hold down SHIFT key
3. Click on the second column header.
Now you will have the second column as the sub-group of first column and you are able to sort a number of columns until you get the right data groups.