I’ve tried searching for a straightforward answer on this and haven’t been able to find one.
We send out multiple communications in our office such as newsletters and invitations.
I’m having a hard time combining/formatting names at the same address so that it’s something like “John & Jane Doe 123 Main St Orlando, FL 12345” without having a separate spreadsheet.
I have individuals as separate records, including spouses/people living at the same address. Each record has many columns to separate out first/last name and street/city/state/zip code as well as formulas to combine names/addresses.
How can I create a new view or linked table that combines names (if applicable, i.e. spouses) at the same address into one record? (Like “Record1 First Name” & “Record2 First Name” “Last Name”). Perhaps this is a many-to-one relationship, but I haven’t figured out how to format it correctly. (For example, a rollup or lookup of the first names plus a formula could work if I could change the comma to " &")
I’m hoping this is something easy to do and I just don’t have enough work experience to have figured it out. Thanks in advance!