Hi Andri

You could do it with Advanced Filter

Select your range of source data
DataFilterAdvanced FilterUnique values onlyCopy to new
Locationselect cell H12 as the new location

--
Regards
Roger Govier

Andri wrote:
Dear Expert,
Please help to create the list automatically.

Here is the situation, for simflify, i just take the Vendors Columns Only.

Supplier (we assume G1 - G12).
Bridgestone
Honey
Bridgestone
Enterprises
Enterprises
Enterprises
Honey
Honey
ALS
ALS
Aircraft

I did success to calculate how many vendors listed above with the following
formula:
{ =COUNT(IF(FREQUENCY(MATCH(G3:G13,G3:G13,0),MATCH(G 3:G13,G3:G13,0))0,1))}
Result = 5 Vendors.

But on the other, i would like to list automatically at Column H1 - H5 for
those 5 Vendors:
H1 = Will be Bridgestone
H2 = Will be Honey
H3 = Will be Enterprises
H4 = ALS
H5 = Aircraft.

Please help which formula can implement that result.

TIA