Hide rows with duplicate values

Amy Evans

Hello,

I have a spreadsheet where the primary column has cell entries where there are duplicate names, which are intentional to show variations. How do I show the primary column where duplicate names are hidden?

Thanks,

Amy

Kleerfyre

I have never seen a way to hide rows, only columns. The only way to "hide" them would be to remove them, but that would mean losing data and that wouldn't be good. If you could have the variations fall into a different column, then you could hide them like that.

Amy Evans

How can I automatically remove the duplicate rows? Is there a way to do this with a formula and not manual?

Thanks,

Amy