Remove rows based on duplicates in a single column in Google Sheets

Question

I have spreadsheet similar to this:

I'd like to remove all duplicates of row based on the first column data.

So from this screenshot row, 1 and 2 would be kept, and row 2 would be removed. Any help would be greatly appreciated.

P.S. In my case I have columns from A to AU and rows from 2 to 9500.

Thank you.

Answer 1

I would...

1. Create a new sheet
2. For column A, do =Unique(Sheet1!A:A)
3. Simply use VLOOKUP to populate the other columns. This will deliver the first value associated with the duplicates.