How to remove duplicates in excel columns?

Question

excel

How to remove duplicates in exel columns,
for example, there is a table with 2 tbsp.
elephant | elephant
hare | elephant
elephant | wolf
elephant | elephant
need what would be an elephant | the elephant lines were deleted if the words matched each other, and the hare | elephant, elephant | wolf remained.
Help please who knows Excel. Thank you!

Answer 1

If you do not disdain Google tables, it is done there easily and naturally:
In D1 :
=ArrayFormula(a:b;a:a<>b:b)

Answer 2

As an option - add another column, in it the formula = if (A1 = B1; 1; 0), stretch to the end, then through the filter (Ctrl + Shift + L) delete all lines where there is a unit in the 3rd column, and then and the column itself