If I get you correctly, whene there was a second value(an e-mail address)
that value went into the next cell below the first data item and nothing ever
went into column B.

From the first line you could put a formula that checks for the presence of
an '@' in the cell below in column A, and if so, copy it.
=IF(ISERROR(FIND("@",A2)),"",A2) this assumes you don't have a column
header. IF so use A3. Copy it down all the way through your range. Verify
your results. Select Column B. Copy. Paste Special -- Values. Sort the
two columns on Column B's values. Delete all the rows that have an e-mail
address in column A and nothing in column B.

IMPORTANT: Of course, backup first in case I have something wrong in what
you're dealing with.

"Tom" wrote:

I have an excel file with over 2000 lines. The data that was imported was
not consistent. One of the fields either had one or two data items, and as a
result, if the field had 2 data values, the 2nd data item was moved into the
A column of the row underneath it. These are all email address. Is there a
way I can create a rule and have them moved into the correct column (up one
row and into column C)?

This also meant the B column next to the email address now needs to be
deleted.

Can anyone tell me what I need to do? Thanks.