# Removing duplicates from a column

**URL:** <https://community.glideapps.com/t/removing-duplicates-from-a-column/45517>\
**Category:** Ask for Help\
**Created:** [July 29, 2022, 11:23am UTC](https://community.glideapps.com/t/removing-duplicates-from-a-column/45517 "2022-07-29T11:23:51Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [July 29, 2022, 2:37pm UTC](https://community.glideapps.com/t/removing-duplicates-from-a-column/45517/3 "2022-07-29T14:37:03Z")

</div>

Some additional information to eliminate the duplicates.

> [@Sort+Group Relationships](https://community.glideapps.com/t/sort-group-relationships/45097/2):
>
> Is this to display in a list? What I would do is first make sure you have a Row ID column. Then create a multiple relation that links the item name to itself. Using that relation, create a rollup column that sums the total quantity for each item. Then create a Single Value column that grabs the Row ID value from the relation (This will be the first matching row ID for that item name). Finally create an IF column then checks if the single value row ID matches the regular row ID. If it does,…

---

_[View the full topic](https://community.glideapps.com/t/removing-duplicates-from-a-column/45517)._
