# Populate data

**URL:** <https://community.glideapps.com/t/populate-data/65581>\
**Category:** Ask for Help\
**Created:** [August 30, 2023, 9:41am UTC](https://community.glideapps.com/t/populate-data/65581 "2023-08-30T09:41:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![syncros](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/syncros/32/83398_2.png) [@syncros](https://community.glideapps.com/u/syncros)\
**Post date:** [August 30, 2023, 9:41am UTC](https://community.glideapps.com/t/populate-data/65581/1 "2023-08-30T09:41:11Z")

</div>

I would like to create a new GLIDE table which brings in the unique values from another table… is there an easy way to do that ?

---

<div class="post-metadata">

**Author:** ![syncros](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/syncros/32/83398_2.png) [@syncros](https://community.glideapps.com/u/syncros)\
**Post date:** [August 30, 2023, 9:45am UTC](https://community.glideapps.com/t/populate-data/65581/2 "2023-08-30T09:45:51Z")

</div>

I can get the data I want to see, but as a calculated value it creates an array of each row… but I would like rows created for each value…

---

<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:** [August 30, 2023, 9:47am UTC](https://community.glideapps.com/t/populate-data/65581/3 "2023-08-30T09:47:56Z")

</div>

Yes. Do it like this:

- Add enough rows to your table to cover the maximum number of unique values
- Add a RowID column
- Add a Lookup column that targets the RowID column. This will give you an array of RowIDs
- Add a Find Element Index column. This should target the array of RowIDs, and look for the RowID. This column will give you a incrementing number in each row, beginning at zero.
- Add another Lookup column that targets the column you want unique values from.
- Add a Unique Elements column that targets the previous column.
- Finally, add a Single Value. This should take X from Start of the previous column, where X is the Row Index number.

---

<div class="post-metadata">

**Author:** ![syncros](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/syncros/32/83398_2.png) [@syncros](https://community.glideapps.com/u/syncros)\
**Post date:** [August 30, 2023, 11:38am UTC](https://community.glideapps.com/t/populate-data/65581/4 "2023-08-30T11:38:01Z")

</div>

wow thats a handful:) I went on the oldschool direction… Google spreadsheet, unique(query(…))

thanks for your time and effort.

---

<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:** [August 30, 2023, 11:57am UTC](https://community.glideapps.com/t/populate-data/65581/5 "2023-08-30T11:57:49Z")

</div>

Using a sheet formula is fine, as long as you don’t care about the sync delay.