How to create an array from column values?

[MaxB]

I’ve seen that there is the ‘unique’ function in glide now, but it works with arrays, and I have my values in a normal column.

How can I use glide to perform the unique values filter, instead of doing it in google sheets?

[AyS_0908]

Hi, something like this?

If yes, use the “Split” computed column

[Darren_Murphy]

You can do a Lookup on the entire column first, and then pass that to the Array->Unique plugin.

[MaxB]

@Darren_Murphy

You can do a Lookup on the entire column first, and then pass that to the Array->Unique plugin.

Yes to that but it gives back another array, while I need values in column, I haven’t found a solution to this yet so i suppose using sheets is the best option

[Darren_Murphy]

How to Flatten a vertical Array (plugin use)

Nice, but you have a couple of extra columns that you don’t need. Once you have your Unique items, then you only need two more columns: the equivalent of your begin column, except start the numbering at zero a single value column, that takes “begin” from start, from the unique column. Here is a contrived example to show what I mean: [Screen Shot 2021-11-06 at 10.52.57 PM] [Screen Shot 2021-11-06 at 10.52.45 PM]