How can I do a multi-level sort in Views? I have a table format view with multiple columns/fields:


Date
Title
Room


And data that looks like this table (as an example):

|    Date       |    Title      |  Room  |

| 4 June 2016   | Yellow-Green  | Apple  |

| 4 June 2016   | Sky Blue      | Orange |

| 1 June 2016   | Magenta       | Apple  |

| 4 June 2016   | Yellow-Green  | Grape  |

I want to sort the data in the table at multiple levels:


First by Date in descending order
Second by Title in ascending order
Third by Room in ascending order


So from the data given, the table would sort in this order:

|    Date       |    Title      |  Room  |

| 4 June 2016   | Sky Blue      | Orange |

| 4 June 2016   | Yellow-Green  | Apple  |

| 4 June 2016   | Yellow-Green  | Grape  |

| 1 June 2016   | Magenta       | Apple  |

Please note that the data all still needs to be in a single table, rather than splitting into multiple tables, thank you.

The effect I'm trying to achieve in how it's like in Excel -- wherein you can sort the cells by levels -- for instance, first sort by Column B, then sort by Column D, etc.

How can I achieve this in Drupal 7 views without writing/editing any code?

Thanks very much in advance for any help.

(I've edited this question to hopefully clear things up.)
In Views, under the "Format" heading you format is already "Table", Click the Settings link, Scroll down until you see "Grouping field Nr.1" and choose date.  Then use "Grouping field Nr.2" for the next one.