Help

How to split a cell into multiple rows

Solved
Jump to Solution
1556 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryan_Banks
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

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.