What would be the easiest way to display two columns and multiple rows of data in one cell? What I want to do is display the types of beds at a single location and the floor on which they appear. So, I have two consecutive columns, Bed and Floor. One entry would be Single and 1st Floor. Still, all the listings would be for the same location. I do not want to repeat the same location in subsequent rows, just to be able to list the data for the Bed and Floor entries. Is there any way of doing this without needing to enter multiple rows for the same place? I've included a sample of what I'm talking about (the data, below; the worksheet, attached)
Type of Bed/Floor (Column A/Column B)
Single/1st (A1/B1)
Single/2nd (A2/B2)
Queen/3rd (A3/B3)
King/4th...
Bookmarks