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?

[image] How to Flatten a vertical Array (plugin use) Ask for Help 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 ze…

Hi, something like this? [image] If yes, use the “Split” computed column [image]

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

[image] 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

How to create an array from column values?

Ask for Help

Darren_Murphy November 9, 2021, 3:25pm 5

Topic		Replies	Views
UNIQUE function in Glide Ask for Help	1	195	February 2, 2024
Copying columns unique values to new column Ask for Help	3	390	June 22, 2023
Populate data Ask for Help	4	274	August 30, 2023
How to Flatten a vertical Array (plugin use) Ask for Help	10	1263	November 6, 2021
Unique Element Ask for Help	1	395	April 15, 2022

How to create an array from column values?

Related topics