Can you think of an easy and fool prove way of using an array within a single cell?
What do I actually want to do?
I need Zapier to push a matrix to coda. This matrix always has columns rows, but a varying number of rows. At the moment I require 1-10, but soon it might be 1-100 (which would make it unfeasible to push the data in individual colums).
So I want to be able to extract “oranges” and “2”, “apples” and “3”, “tequilla” and “5”.
As soon as the cell with “Oranges, Apples, Tequilla” is recognized as an array, I could just use the nth()-forumla. But is there any way to get it to that point?