# UNIQUE function in Glide

**URL:** <https://community.glideapps.com/t/unique-function-in-glide/70401>\
**Category:** Ask for Help\
**Created:** [February 2, 2024, 7:06am UTC](https://community.glideapps.com/t/unique-function-in-glide/70401 "2024-02-02T07:06:38Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [February 2, 2024, 8:17am UTC](https://community.glideapps.com/t/unique-function-in-glide/70401/2 "2024-02-02T08:17:54Z")

</div>

Creating a unique array is quite simple, and requires two columns:

- Create a Lookup column that targets your Data column
- Use a Unique Elements column that targets the Lookup column

If you then need to expand the array into a list that spans multiple rows, you will need some extra columns:

- Add a RowIndex column to number your rows from 0-N. You can either do that manually, or use the second method described [here](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572).
- Add a Single Value column. It should target your Unique Elements column, taking N from start, where N is your RowIndex column.

---

_[View the full topic](https://community.glideapps.com/t/unique-function-in-glide/70401)._