# Unique Element

**URL:** <https://community.glideapps.com/t/unique-element/40720>\
**Category:** Ask for Help\
**Created:** [April 14, 2022, 3:33pm UTC](https://community.glideapps.com/t/unique-element/40720 "2022-04-14T15:33:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [April 14, 2022, 3:33pm UTC](https://community.glideapps.com/t/unique-element/40720/1 "2022-04-14T15:33:21Z")

</div>

hi everyone  
How to apply `unique formula` in GT…  
When there are multiple data, I want to make it only one data.  
in Glide Table I use a `unique element`, but it removes the horizontal double data, and that’s not what I expected.  
I want a `unique element` to work on vertical data, like the following screenshot, can it be done?

 ![Screenshot_2022-04-14-22-19-58-892_com.microsoft.office.excel](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15abf181fca7eef33776d5c2ee66ab82fe69b1cf.jpeg)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 15, 2022, 12:11am UTC](https://community.glideapps.com/t/unique-element/40720/2 "2022-04-15T00:11:28Z")

</div>

There are several ways to approach this. What do you want to do with the data afterwards?

If you want some sort of a “unique category”, I would do it like this:

In the same table as you show above:

- Create a lookup column to return an array of all names.

- Create a plugin column to return unique elements of the array. (Array \> Unique elements)

Then, create a new table called “Categories”.

- Create as many rows in advance as needed (this must be manually done).

- Add a rowID column for the “Categories” table.

- Create a lookup to return all rowIDs of this table.

- Use the plugin Array \> Find Element Index to have an index starting from 0 of each row (find each row’s rowID in the array of rowIDs created).

- Use a single value column to bring the list of unique elements from the Names table.

- Use a single value column, use “From start” option, point to the index column 2 steps above, with the array being the array brought back from the Names table.