Listzing distinct values

In col A I have 10 values - currencies

If a particular currency is in col A I want this to be part of a list in Col B

So For example

My input in col A:


EUR
GBP
GBP
GBP
USD
USD
TKL
EUR
JPY
TKL

Output in col B would be:

EUR
GBP
USD
TKL
JPY

Many Thanks in advance

Add a header cell (with anything in it), click in col A, then Data > Filter > Advanced Filter, select Copy to another location, List Range e.g. A1:A10, Copy to B1 and tick unique records box.