Here is some macro code that will delete duplicate rows. Is that what
you want?
Sub RemoveDuplicates()
Dim totalrows As Integer
Cells.Sort Key1:=Range("A1")
totalrows = ActiveSheet.UsedRange.Rows.Count
Count = 1
For Row = totalrows To 2 Step -1
If Cells(Row, 1).Value = Cells(Row - 1, 1).Value Then
Rows(Row).Delete
Count = Count + 1
End If
Next Row
End Sub