Concatenate & Remove Duplicate

[peelamedu_bulls]

I have the following column values

Input
Account no Code
000005678 ABC
000005678 EDF
000001234 ABC
000001234 ABC

Desired Output
Account no Code
000005678 ABC
000005678 EDF
000001234 ABC

Criteria
Concatenate Column A and B (i.e Account No and Code)
If there are duplicates of this concatenated data, remove duplicates

I'm able to do this in VBA in a round about way, i.e create a column to concatenate two columns and then create one more column and use countif to determine if there are duplicates and then remove the duplicate. But it's long, and not elegant. Trying to avoid these calculation columns in the final output.

Is there a more elegant solution to this problem ?

 

[Fluff]

There's a thread on here somewhere (possibly more than one) that demonstrates the potential problems, but I can't find it.
Suffice to say that rows which should be considered duplicate & deleted aren't.