Hotel Rooming List, sorted by category of room (Single Double etc)

Hi everybody, I am Robert
I have a passenger list stating names (...) and the type of rooms they wish. On the passenger list, all types of rooms are mixed.
I now want to have different additional tabs for the types of rooms, on which the passengers are stated according their wishes. i.e. on Tab "Single Rooms" I have listed all passengers preferring single rooms, on Tab "Double Rooms" those who wish doubles etc.
Is that possible in general, and how?
Thanks for your hints!

Here's the sample file. I do however not manage to find the "Go Advanced" button.

Thanks! Robert

Thank you so much, Siva! It's excellent.