In general Views Aggregator Plus and Views Calc can both generate tally reports like these.
Unfortuntaley by making
text list you've basically made it (nearly) impossible for you to easily generate these types of reports. You're question isn't really a Views question, but 1 of how to write a tally report in
rooms is a simple string, its hard(er) to
SUM the values to make your report. If the
room was a
reference to a
room ID in another table then SQL, and Views and
aggregation functions could more easily generate these reports.
Is this possible to do with Views, and then HOW to do it?
TLDR; Yes, it's possible. It's easier if you make your data into non-string values for aggregation. It's a futile effort to show you how because it's simply too messy in code to work with the data structures you've created.
If these were numerical numbers for the number of rooms, or room IDs, you could easily use
SUM aggregation to find the total. Then you would simply use a Views
rewrite substition to show the output as something like the string
[node-room-sum] x [node-room-size] room(s) aparament and use tokens derived from your View.