Aggregate and Concatenate

[Rbooth]

Hello, I have a dataset of property owners, some of whom own multiple properties. Whenever I add them to my database, I need to group up all of the property each owner has into one cell next to their name. Otherwise, I'll have 4 contacts with the same name just different properties.

I have attached the data set below. In the past, I have:
A. Manually Aggregated
B. Long Concatenate/Nested If Statement

Just looking for the most efficient way to create a single cell next to each individual property owners name, with a list of all of the other properties in the dataset that they own. Ex. 123 Main St. | 321 Niam St. etc... Any help is much appreciated.

Lastly, if you have a more appropriate title let me know!

TIA

Not sure how to upload the spreadsheet, so here's the idea (Names and addresses have been changed to protect privacy)

Owner 1 <colgroup><col></colgroup><tbody> </tbody>	Also Owns <colgroup><col></colgroup><tbody> </tbody>	Property Address <colgroup><col></colgroup><tbody> </tbody>	Owner Address <colgroup><col></colgroup><tbody> </tbody>
Adel A Ibrahim <colgroup><col></colgroup><tbody> </tbody>	81 Maury St <colgroup><col></colgroup><tbody> </tbody>	64 Fain St <colgroup><col></colgroup><tbody> </tbody>	1234 Glenrose Ave <colgroup><col></colgroup><tbody> </tbody>
Adel A Ibrahim <colgroup><col></colgroup><tbody> </tbody>		81 Maury St	1234 Glenrose Ave <colgroup><col></colgroup><tbody> </tbody>
Alberto Alejandro Ayala De La Cruz <colgroup><col></colgroup><tbody> </tbody>		3 Duncan St <colgroup><col></colgroup><tbody> </tbody>	321 Main St.
Tony R Powell <colgroup><col></colgroup><tbody> </tbody>		44 Fain St <colgroup><col></colgroup><tbody> </tbody>	1020 Lischey Ave <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>