Index only showing first instance, need to show both/all instances
I'm not sure how to phrase this. I am new to Numbers. I have created a "neighborhood phone book" database in Numbers. End result is 1) export to CSV, 2) Datamerge in Adobe InDesign. In Numbers I have one tab with all resident's info. In another tab I have created a "street index" which pulls info from the first tab and organizes by street to create an index. In the main residents tab there are some people with second marriages or people who live together and have different last names but live at the same address. That all works fine. There is ONE instance where it does not work. An adult daughter who lives with her parents. All same last name, all same address. The daughter's name comes up first by alpha in the residents tab. For some reason, in the street index, ONLY her name comes up, and not BOTH her name and her parents' names. Also for some reason it WORKS for "Urban" (same situation). Not really sure how to make this work and have the parents' info included in the index. Any help is appreciated.
Street Index results
[Edited by Moderator]