Compare and delete data

Hello,

Here is the scenario. I have 2 columns with names in excel. I need to compare both the rows and get the extra rows out.

Column A Column B

A A
B A
B B
C C
C C

I need to get a result so that all the duplicates are deleted and collected in a seperated sheet or column and the end result should look like.

Column A Column B Column C
A A A
B B B
C C