I have a list of reviews, media, and info on certain establishments (Restaurants, Bars ,etc.) many have one location which is fine, some of 2+ and I want to list the establishment info on the sheet I have, and then just have all the locations for the establishment be available from another tab.
This way my map tab can be driven from that sheet and all the locations, while the establishment tab can show all the places once, and then each location can be shown as an inline list or something.
The alternative I just copy each establishment and have a row for each location and just maintain them as separate rows.
It would be great to manage the establishments from a separate sheet with locations there.