# Copying columns unique values to new column

**URL:** <https://community.glideapps.com/t/copying-columns-unique-values-to-new-column/63063>\
**Category:** Ask for Help\
**Created:** [June 22, 2023, 5:23pm UTC](https://community.glideapps.com/t/copying-columns-unique-values-to-new-column/63063 "2023-06-22T17:23:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![msamps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/msamps/32/71072_2.png) [@msamps](https://community.glideapps.com/u/msamps)\
**Post date:** [June 22, 2023, 5:23pm UTC](https://community.glideapps.com/t/copying-columns-unique-values-to-new-column/63063/1 "2023-06-22T17:23:47Z")

</div>

I currently use this formula on google sheets: =UNIQUE(‘Sheet1’!N:N)

Is there a way to do this on glide so that I don’t have to wait for the data to refresh and can have everything in realtime?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 22, 2023, 5:38pm UTC](https://community.glideapps.com/t/copying-columns-unique-values-to-new-column/63063/2 "2023-06-22T17:38:29Z")

</div>

> [@Select colA from Glide Table](https://community.glideapps.com/t/select-cola-from-glide-table/63047/2):
>
> A few ways to approach this. Here is one way. You would do the following in your Catalog table: Make sure your table has a RowID column. Create a multiple relation that matches the name with itself. Create a Single Value column that takes First-\>RowID from the relation column. Create an if-then-else column: – If RowID is Single Value RowID, then Name The if-then-else column should contain a list of unique names

---

<div class="post-metadata">

**Author:** ![msamps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/msamps/32/71072_2.png) [@msamps](https://community.glideapps.com/u/msamps)\
**Post date:** [June 22, 2023, 5:51pm UTC](https://community.glideapps.com/t/copying-columns-unique-values-to-new-column/63063/3 "2023-06-22T17:51:12Z")

</div>

Im a little bit confused. Im not looking for entirely unique rows. I just want to extract on the unique values from a singular column so that there arent any duplicate entrys in my list component

---

<div class="post-metadata">

**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:** [June 22, 2023, 5:53pm UTC](https://community.glideapps.com/t/copying-columns-unique-values-to-new-column/63063/4 "2023-06-22T17:53:46Z")

</div>

If you follow the steps in the post that Jeff linked to, you can use the resultant if-then-else column as a filter on your list. ie. only show records where the if-then-else column is not empty.