1) Add a row at the top of the Sheet and type bla bla as the header in cell A1.
2) Select the whole range and run an "Advanced Filter" while selecting "Only
Unique Records".
3) Copy the filtered range and paste into cell B1.
Micky


"Maracay" wrote:

Hi Guys

I have a column (A) with different concepts repeated several times, what I
want is to show those concepts 1 time in column B, ex.

Column A Column B
Car Car
Bike Bike
Car Bus
Bus Airplane
Bus
Car
Car
Bus
Bike
Bike
Airplane


Thanks