Deleting duplicate cells in excel
 

I have a excel list with duplicate data in several rows and only want it to display the data once and delete all duplicates, is there a quick way of doing this? I think Woj is sleeping :(

Nevermind, figured it out :)