# Help with distinct values

**URL:** <https://community.make.com/t/help-with-distinct-values/77863>\
**Category:** Questions\
**Tags:** google-sheets, functions\
**Created:** [April 7, 2025, 12:30pm UTC](https://community.make.com/t/help-with-distinct-values/77863 "2025-04-07T12:30:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Simon3](https://avatars.discourse-cdn.com/v4/letter/s/dec6dc/32.png) [@Simon3](https://community.make.com/u/Simon3)\
**Post date:** [April 7, 2025, 12:30pm UTC](https://community.make.com/t/help-with-distinct-values/77863/1 "2025-04-07T12:30:04Z")

</div>

Hi,  
I am fetching values from a google sheet. Some values are redundant. In my case they are

- IBAN1
- IBAN1
- IBAN1
- IBAN2
- IBAN2

I want to use only the values IBAN1 and IBAN2 once, but I cannot solve this.

Really looking forward to reading from you,  
Simon

---

<div class="post-metadata">

**Author:** ![ponvaskon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ponvaskon/32/67139_2.png) [@ponvaskon](https://community.make.com/u/ponvaskon)\
**Post date:** [April 7, 2025, 1:11pm UTC](https://community.make.com/t/help-with-distinct-values/77863/2 "2025-04-07T13:11:15Z")

</div>

Hi @Simon3

You can add all values to an array and use the duplicate function.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/e/3e232ca2e9794e70b514d8bbe8f2c70e3c129453.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/f/5f4258254dc987c098de4c49a712e3d33b580842.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [April 7, 2025, 4:28pm UTC](https://community.make.com/t/help-with-distinct-values/77863/3 "2025-04-07T16:28:27Z")

</div>

If the values are in different bundles, you can simply use an array aggregator and group by that columns value.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [July 6, 2025, 4:42pm UTC](https://community.make.com/t/help-with-distinct-values/77863/4 "2025-07-06T16:42:32Z")

</div>