I am trying to create a view based on rooms and multiple items within that room. Is there a way for me to just output the room number once at the top and then the related records for that room beneath? Currently, i have it grouped by room in view, and the records just show up in rows with the room number on each.
Current:
Room 111 table
Room 111 chair
Room 222 lamp
Desired:
Room 111
Room 222