I have some data including same or unique name in different cells.

e.g

ABC
ABC
ACC
ADD
AEE
AEE

I would like to ask how can just show the same name in once(not duplicate)


result:

ABC
ACC
ADD
AEE