# How to create an array from column values? **URL:** \ **Category:** Ask for Help\ **Created:** [November 9, 2021, 10:57am UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246 "2021-11-09T10:57:44Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 9, 2021, 10:57am UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246/1 "2021-11-09T10:57:44Z")
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? ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [November 9, 2021, 11:06am UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246/2 "2021-11-09T11:06:42Z")
Hi, something like this? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/81c1f4375cb318d1e80342e7f49f57923e0e25d6.png) If yes, use the “Split” computed column ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/255d667848e412b1c71344bbb0977aec06459acf.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 9, 2021, 11:06am UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246/3 "2021-11-09T11:06:50Z")
You can do a Lookup on the entire column first, and then pass that to the Array-\>Unique plugin. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [November 9, 2021, 2:35pm UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246/4 "2021-11-09T14:35:06Z")
> [@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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 9, 2021, 3:25pm UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246/5 "2021-11-09T15:25:21Z")
> [@How to Flatten a vertical Array (plugin use)](https://community.glideapps.com/t/how-to-flatten-a-vertical-array-plugin-use/34111/6): > > 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: ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 11, 2021, 11:24am UTC](https://community.glideapps.com/t/how-to-create-an-array-from-column-values/34246/6 "2021-11-11T11:24:22Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.