Special condition to make a list when having 2 values in a cell of column in airtable

I am having only 1 column in airtable database and data stored in it is :-

Mango - ₹100
Banana - ₹150
Pomegranate - ₹200

Now as u can see in each cell there are 2 values but now I want to separate it in two list in variable
Like below

List 1:-
Mango
Banana
Pomegranate

List 2:-
₹100
₹150
₹200

You can see there was a - (symbol) to separate it.
I don’t know how to start do this. As it is a bit complex cuz having two values in a cell.

Airtable has applied API limits so be careful if using free plan else your app won’t run as expected.

It is as much as simple

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