I have a long table with 3 columns. The first column does not always have a value (integer, 6 digits) in it, but is unique when it does. The second is the type, with 4 separate values all the columns are. Then the third column is the name, also unique. Looks like so:
| A | B | C | 1 | 123456 | Type | Data1 | 2 | | Type | Data2 | 3 | 123457 | Type2 | Data3 | 4 | | Type | Data4 |
What I want is it to sort in order 1, 3, 2, 4. I want the first column WITH values at the top, and then the name (Column C) sorted A-Z. I then want the rows with nothing in column A at the bottom, still sorted with Column C. Is this possible in either Excel 2007 or Excel 2013?