Any way to consistently tell which entry has two rows and which has one row?

Post a sample of some rows.


Gord Dibben MS Excel MVP

On Fri, 19 Dec 2008 05:34:01 -0800, 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.