Keep single value from a list of duplicate values

I have a whole list of Excel duplicate data which I have filtered now I have to keep one row from each duplicate row(s) how to do it

1 Reply

Try 'Remove Duplicates' on the Data tab of the ribbon.