how to make a column of repetative data become unique?

[mango]

dear all,
what function to use to get the result?

course ---------> course
risk management risk management
risk management safety tips
risk management
safety tips
safety tips
safety tips
safety tips

 

[Frank Kabel]

Hi
have a look at 'Data - Filter -Advanced Filter' and
check 'Unique records'