I don't understand what you want to do. You say the data is in one column but
different rows and you want to get the address and citystatezip into
different rows. Can you post a sample of the existing data and a sample of
how you want them to look.

Regards,

OssieMac

"kimbafred" wrote:

I have a file that came out of a program where the Name, address,
citystatezip are in the same column but different rows. I have some 1400
names in this column and I need to get the address and citystatezip in
different rows so I can do a mail merge