How to remove/hide duplicate rows

To Remove duplicate rows:
Select the table containing duplicated rows, click Data on the toolbar-->Click Remove Duplicates
Select the columns to include in identifying duplicates, click OK. This deletes away all the repeated rows

To just Hide duplicate rows
Select the table containing duplicated rows, , click Data on the toolbar-->Filter-->Advanced
Check Unique records Only and Click Ok.

To unhide, just click Clear beside Filter