Ignore duplicates in data validation list

Hi all,

I would like to show no-duplicates in a data validation list. See example below: I have my data validation as suppliers and products, and my table was I have the drop-down list of suppliers that shows all the supplier, including repetitions, I need to get rid of repetition without making any changes on the DATA sheet.

Any ideas?

Thanks!

One way to do this is to turn it into a Pivot Table and point your Data Validation list at that instead, please see attached.