Formula Help - Array of Array's

Dear AG,

I am trying to extract a list of strings from an array of an array of objects.

Data example:
[ [ {label:mobile, number: +447123456789}], [ {label:mobile, number: +447987654321} ] ]

I would like returned an array of strings as such:
["+447123456789", “+447987654321”]

I would be extremely grateful if anyone could provide any pointers here!

The VALUES function should do that

1 Like