Customers took two separate surveys : How to extract customers that took both + survey score?

[kalamazoo]

I have an excel worksheet with 4 columns. Around 10,000ish customers.

Column A (Customers took 1st survey)
Column B (Score on 1st survey)
Column C (Customers took 2nd survey)
Column D (Score on 2nd survey)

Now some customers took the 1st survey, some took the 2nd survey, some took both.

I would like the ones that took both. What is the best way to go about extracting the customers that took both, with their scores on the 1st and 2nd survey?

Thank you for your help,

J

 

[kalamazoo]

That worked fantastically well. Thanks for all of your help.