Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to split a cell into multiple rows

Solved
Jump to Solution
268 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.