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)
[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Owner 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 212"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Also Owns[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Property Address[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Owner Address[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Adel A Ibrahim[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 212"]
<colgroup><col></colgroup><tbody>[TR]
[TD]81 Maury St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]64 Fain St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1234 Glenrose Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Adel A Ibrahim[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]81 Maury St[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1234 Glenrose Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Alberto Alejandro Ayala De La Cruz[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]3 Duncan St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]321 Main St.[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Tony R Powell[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]44 Fain St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1020 Lischey Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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)
[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Owner 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 212"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Also Owns[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Property Address[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Owner Address[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Adel A Ibrahim[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 212"]
<colgroup><col></colgroup><tbody>[TR]
[TD]81 Maury St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]64 Fain St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1234 Glenrose Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Adel A Ibrahim[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]81 Maury St[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1234 Glenrose Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Alberto Alejandro Ayala De La Cruz[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]3 Duncan St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]321 Main St.[/TD]
[/TR]
[TR]
[TD][TABLE="width: 179"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Tony R Powell[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 116"]
<colgroup><col></colgroup><tbody>[TR]
[TD]44 Fain St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1020 Lischey Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]