How to split a cell into multiple rows

Hi Airtable Community!

I am a new user on Airtable and I am struggling to split incoming data, that contains multiple data points contained in a single cell, into multiple rows. Example Below:

Current format:

| Household | Household Member First Name | Household Member Surname | HHM Age |
| HH1 | John, Jane | Smith, Doe | 18, 19 |

Desired format:

| Household | Household Member First Name | Household Member Surname | HHM Age |
| HH1 | John | Smith | 18 |
| HH1 | Jane | Doe | 19 |

Any ideas on how to achieve this?

Thanks :slight_smile:

Ryan.

This is not natively possible in Airtable.

Splitting data like the data that you listed above is only possible by writing your own custom JavaScript code or using a low-code tool like Make.com.

Where is your incoming data coming from?

If it’s coming from another app, then you might be able to have Make.com act as the middleman between the other app & Airtable, and have Make split each individual record properly before even sending it into Airtable.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.