# How to remove duplicate data in same column?

**URL:** <https://community.glideapps.com/t/how-to-remove-duplicate-data-in-same-column/54328>\
**Category:** Ask for Help\
**Created:** [November 17, 2022, 5:47am UTC](https://community.glideapps.com/t/how-to-remove-duplicate-data-in-same-column/54328 "2022-11-17T05:47:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kelz\_Tan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kelz_tan/32/50511_2.png) [@Kelz\_Tan](https://community.glideapps.com/u/Kelz_Tan)\
**Post date:** [November 17, 2022, 5:47am UTC](https://community.glideapps.com/t/how-to-remove-duplicate-data-in-same-column/54328/1 "2022-11-17T05:47:07Z")

</div>

i have column named ‘Month’, as below:

Month Income  
Oct 2022 15.50$  
Oct 2022 80.00$  
Oct 2022 45.60$  
Oct 2022 125.50$  
Nov 2022 75.90$  
Nov 2022 0.00$

i want to remove duplicate of the month and get the Sum of every month. like example:

Month Total Income  
Oct 2022 266.60$  
Nov 2022 75.90$

---

<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:** [November 17, 2022, 5:48am UTC](https://community.glideapps.com/t/how-to-remove-duplicate-data-in-same-column/54328/2 "2022-11-17T05:48:39Z")

</div>

- create a multiple relation column that matches the month column to itself.
- do a rollup-\>sum through that relation