Hi , Can someone help me with this problem

I want to compare a list of tape media with another , The results should
show missing media and new media in separate columns

An example

First Inventory Second Inventory Missing Media New Media

TAPE01 TAPE01 TAPE07 TAPE11
TAPE02 TAPE02 TAPE08
TAPE03 TAPE03 TAPE09
TAPE04 TAPE04 TAPE10
TAPE05 TAPE05
TAPE06 TAPE06
TAPE07 TAPE11
TAPE08
TAPE09
TAPE10

Any help appreciated

Regards

Mike