# Unique values to be added to new table

**URL:** <https://community.glideapps.com/t/unique-values-to-be-added-to-new-table/79978>\
**Category:** Ask for Help\
**Created:** [February 11, 2025, 6:34am UTC](https://community.glideapps.com/t/unique-values-to-be-added-to-new-table/79978 "2025-02-11T06:34:10Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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 12, 2025, 12:52am UTC](https://community.glideapps.com/t/unique-values-to-be-added-to-new-table/79978/4 "2025-02-12T00:52:06Z")

</div>

Yes.

- Create a table and index the rows using the second method described [here](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572).
- Add enough rows to cover the total number of unique categories
- Create a lookup column that targets the Category column in your transactional table. This will give you an array of Categories.
- Use a Unique Elements column to remove duplicates from the array
- Use a Single Value column, taking the Nth from start of the previous column, where N is the Row Index number. This should give you a list of Categories, one in each row.
- Create a multiple relation column, matching each Category with the same column in your transactional table
- Create whatever rollups you need via that relation.

---

_[View the full topic](https://community.glideapps.com/t/unique-values-to-be-added-to-new-table/79978)._