Help

Combining Rows into one

1848 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Malone
4 - Data Explorer
4 - Data Explorer

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

3 Replies 3
Anonymous
Not applicable

Hi Daniel,

This can be done and one of the great features of Airtable. I’d love to chat with you further via phone to put your ideas in action. If your interested, you can schedule a call with me at www.WiseDesign.co/schedule

frank_johnson
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @Daniel_Malone

I understand your requirement and will be glad to assist you.

let us have short Discussion/call over Skype @ cis.am3 to process further.

Thanks
Frank

Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi Daniel,
Not sure whether you managed to get this working as yet.
If not feel free to hit me up on andrewjohnson56782@gmail.com as this is within my skill set
Best Wishes,
Andrew