Remove duplicates in look up field

[Mathias_Elmose]

I’m a big fan of look-ups but I would really like to be able to remove records the occur more than one time. Is there a way to do that?

[Venger]

Hello everyone.
This works: https://community.airtable.com/t5/other-questions/going-mad-trying-to-avoid-duplicates-with-arrayuni...

answer given by W_Vann_Hall 

[JenniferMM]

Just another person +1ing the need for this feature, years and years later.

I get that there's a work around and I'm sure with enough time and focus I could figure out how to do it, but as someone who is constantly bringing organizations I work with to airtable, it would be great to have a way to do this clearly useful function without having to have a fundamental understanding of coding/programming to make it happen. 

[Tito_Alverio]

Sharing the simplest way I found to do this without the need for scripting or automations. Copying my email to Airtable support:

This was resolved to my expectations by taking the following steps:

1. Create the rollup field in Table A on the Linked Table B’s field I want to rollup, in this case a multiselect field.
2. Take that same rollup field that was just created, and change it to a Lookup field.
   1. (The lookup field will now display as text, instead of the colorful word bubbles you usually see from multi-select fields)
3. Create a formula field in the Table A, and ARRAYUNIQUE the “formerly a rollup now a lookup field” field.
4. Ta-da

Is Airtable aware of this strange behavior? If so, can we make it simpler and more intuitive to get unique values out of rollup or lookup fields?