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.