Hi members:

I have a mailing list that has 5 - 6 rows per address. it is in the following format:

Acct. #
Name
Address
Town, ST zip-code

For about 10% there is an additional line for Country if Foreign

I have several thousand of these in a column in Excel. I would like to put each row into a seperate column so that I could break them apart for sorting by name or state.

I have tried to use the "Transpose" but it is not cooperating with several thousand rows.

Any help appreciated.

Michael