Repeating data shown once

[Slyslap]

I have columns of data that I want to produce report off. Col A could have
a,a,e,s,d,a,s,d.
I want to generate a report column that will show the singular and ignore the repetetion.
ie. a,e,s,d.
Thanks

 

[PaddyD]

depending on what you mean by 'report', there could be a number of options - how about using advanced filter to 'copy unique values only'....