Hello-

I am working on a huge spreadsheet for work and I have multiple values in a column, like so:

AAA
BBB
BBB
BBB
CCC
DDD
DDD

I need it to read:
AAA
BBB


CCC
DDD


(In other words, I still need the rows intact, just the duplicate values eliminated).

Help please?

Thanks!