I’m importing data from a CSV with a nested appearance like this:
| Food Group | Food |
|---|---|
| Fruit | bananas |
| apples | |
| oranges | |
| Veg | kale |
| squash | |
| Cauliflower |
I need to flatten the nesting to look like this:
| Food Group | Food |
|---|---|
| Fruit | bananas |
| Fruit | apples |
| Fruit | oranges |
| Veg | kale |
| Veg | squash |
| Veg | Cauliflower |
Presently I’m using a complicated formula in Google Sheets before importing. Can this be done in Airtable instead?
Thanks very much
