Excel 2007 : Unique record filter - macro or formula

Hi,

I have a huge spreadsheet (950K rows) that i need to filter. Basically, some of the rows are duplicated and I am trying to filter them out in order to have a table without duplicates. I usually use the advance filter - unique records only or pivot tables but with 950K it takes forever. I also tried access but because of large data size access gives me an error message when i try to do a pivot table. I am wondering if there is a macro or formula I can use to solve my problem. Attached is an example of what the table looks like and the table I am trying to obtain. Thanks in advance.