Force array columns

I have some columns “email 1” and “email 2” and for some reason, no matter what I do with them I can’t get them into an array.

I have the same column headers in another sheet with no issues.

Anyone have any ideas or experience of this?

Is it a google sheet or glide table?

Based on a google sheet

hmm, are the columns next to each other? Any extra spaces in some of the headings? Have you refreshed the builder since adding them? Got a screenshot from the google sheet?


They weren’t in google sheets, but were in the glide table. Put them together in google sheets and all is good. Didn’t realise that was required. Whoops.

That has been on my to do list for 3 weeks and bugging the hell out o me and you sorted it in 2 posts. Many thanks.