Excel super gurus

[quickshot89]

Right I have abit of a task on my hand. I have recently done a physical inspection of a DC to confirm what is powered on and what isnt. I have the master spreadsheet with the information of the units and another spreadsheet with the results of the inspection. With over 10000 lines I really dont want to do each line one by one. Ive been told pivot tables might be the solution. Below is a really bad example of what information each spreadsheet has. and what i need it to be

Master | Inspection Data

SN ASSETTAG FOUND SN ASSETTAG POWER?
abc123 unit1 n abc123 unit1 Y

Master EDITED

SN ASSETTAG FOUND
abc123 unit1 Y

 

[quickshot89]

Not sure if I just havnt worded it correctly, but its over two spreadsheets (or worksheets as they are now called) not the same one, If it were on the same worksheet it would be easier, but its spread over 2

 

[quickshot89]

bit of a bump as its to do with the same spreadsheet.

Anything I do seems to cause excel to hang for a few minutes and is unresponsive. I have split the SS into different areas to help trim the file size down, however it hasn't really helped. I have tried a repair on office and it has made no difference. Auto calculations turned off and set to manual, multi-core enabled using all 4 cores.

Excel only seems to use 25% of the CPU usage. Either when I am able to use the spreadsheet or when it hangs.

Is there anything I'm missing or does anyone know a solution