Formula to only show multiple occurances only once

Hi all,

I am in search of a formula which will extract the name of a supplier, which appears multiple times in a list, only once.

Please have a look at the attached file if you are interested in helping.

Many thanks

Raidon