Hi,

I only have a basic understanding of Excel and have a problem that I'm hoping someone will be able to help with.

I have a spreadsheet which currently has 4 columns. Column 1 is a series of purchase order numbers, and column 2 is a list of email addresses associated with those orders. There are 219 rows or entries in both columns.

In column 3 I have the purchase order numbers again and in column 4 I have a list of first names associated with those orders. The problem is that in columns 3 & 4 I only have a total of 155 entries or rows. So I need to find a way of grouping columns 3 & 4 and then matching them to column 1 so that the names match the corresponding email addresses and that there are blank cells where there should be.

If someone could please help I would really appreciate it. I'll probably need a step by step idiots guide if possible please!