Array Column

Combine multiple columns into a single column

Array Columns are currently only supported in Google Sheets. They don't work with Glide Tables.

Array columns combine the data from multiple columns together into a single column in the Data Editor. To make an array column we create columns with the same name and then number each one sequentially. It’s important that each column has the same exact text and then the next number in each column. For example:

In the data editor, we can see that our 6 columns have become a single column with all the values from all 6 columns.

We can use this Array Column in a variety of ways. One example is creating an Image Carousel. If we add an image component and choose this new Array Column as the source, our image component turns into an image carousel displaying all the images in our Array Column.

You can use array columns in other ways, for example in relations, per user filtering and row owners.