List Management

I'm using Excel to track data on my company's email marketing. I have a master list of all my email contacts. I have lists of which email address opened each email we've sent out in the last few months.

Is there a simple way to sort the lists so that the rows line up matching content?

I'd like it to look like this:

Master...Email 1...Email 2...Email 3
Jim.........................Jim.........Jim
Misha....Misha
Alan
Jacquie.Jacquie...Jacquie...Jacquie

This way I'd know I should remove Alan from my list because he's never opened anything, and I should keep an eye on Misha because she only opened my first email.

Is there a series of commands that will do that, or should I resign myself to handling this manually?

I'm not sure if I can upload anything in this forum, I don't see any buttons for attachments.

For this problem, my data is all text.

Basically, I have a list of about 1000 people who signed up for our e-blasts. About 300-400 open any given email. We'd like to weed out the folks who aren't opening it, since our email client charges per contact.

I'm able to download a csv listing who opened each individual email from the server, and I'd like to cross check them against each other.

I have my columns set up as Master List, then Email 1, Email 2, Email 3, etc.
As I read across the columns, I'd like to be able to see the contact's name if he/she opened an email. So if Row 4 reads Jim, blank, blank, Jim, Jim, then I'll know that Jim didn't open the first 2 emails I sent out, but he did read 3 and 4.

Does that make more sense?

I'll try HTML, too.

HTML Code: 

<table border=1><tbody><tr><td>Master</td><td>Email 1</td><td>Email 2</td><td>Email 3</td><td>Email 4</td></tr>
<tr><td>Jim</td><td></td><td>Jim</td><td>Jim</td><td>Jim</td></tr>
<tr><td>Misha</td><td>Misha</td><td></td><td></td><td></td></tr>
<tr><td>Alan</td><td></td><td></td><td></td><td></td></tr>
<tr><td>Jacquie</td><td>Jacquie</td><td></td><td>Jacquie</td><td>Jacquie</td></tr>
</tbody></table>