I need to combine multiple rows into one, where one of the columns is a linked record.
Owners Table
Column 1: Owner Name
Column 2: Cars (linked to records on the Cars table)
Right now on the Owners Table, there is a row for each car the Owner owns.
So it looks like this:
Name | Cars
Bob | Camaro
Bob | Mustang
Bob | Challenger
I’d like to look like this:
Name | Cars
Bob | Camaro, Mustang, Challenger