Sep 15, 2022 03:13 AM
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 :slightly_smiling_face:
Ryan.
Solved! Go to Solution.
Sep 15, 2022 03:23 AM
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.
Sep 15, 2022 03:23 AM
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.