Line up columns where row values match

Hi Excel Help, you've been extremely helpful in the past and I greatl appreciate it.

I've had this problem before and have not found a good solution.


Column A:_____________Column B

House_____________Car
Car_____________Farm
Farm_____________iPad
Dog_____________Surface
iPad_____________

I want to line up these lists by row, leaving blanks, or something such as #N/A, where they would occur..Leaving something like:

Column A:_______Column B
House__________Blank or #N/A
Car____________Car
Farm___________Farm
Dog____________Blank or #N/A
iPad____________Blank or #N/A
Blank or #N/A____Surface


I've played around with V lookups and functions to explain which are missing in column B vs A, and vice-versa, but what's the best way to just create a table with them lined up?

Thanks,
Andrew

Thanks Fdibbins,
I've gotten this far with the vlookups. But is there a non-manual way of taking it a step further and lining up the columns as I (tried to) exlain in my post?
Thanks.

Thanks Fdibbins,
I've gotten this far with the vlookups. But is there a non-manual way of taking it a step further and lining up the columns as I (tried to) exlain in my post?
Thanks.