Is there any way within airtable to return multiple row headers based on a column match? I have an example below. Basically my master base is company-focused but I have two fields "Investors" and "Investments" which would both be matching items in the "Name" field. Ideally I want to be able to tag "Investor(s)" in a column but have the "Investment(s)" column auto-populate pulling in "Name" based on a match of "Investor(s)" to "Name" in that particular row.
Name | Investor(s) | Investment(s) |
Startup A | Investor A, Investor B | |
Startup B | Investor A | |
Startup C | Investor B | |
Startup D | Investor A, Investor D | |
Company A | ||
Investor A | Startup A, Startup B, Investor D | |
Investor B | Startup A, Startup C | |
Investor C | ||
Investor D | Startup D |