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

If you have fixed number of rows for each record, then it is easy to
transpose it as you want.
Since you have 5 or 6 rows for different records, then it is very difficult
achieve what you want, even using VBA code.

If all are five rows in column A starting from A1, then use the following
formula in Cell B1:

=OFFSET($A$1,5*(ROW()-1)+COLUMN()-2,0,1,1)

and copy the formula , paste in range B1:F100


--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Tool & Training Material for Download
==================================
"mjmoore" wrote in message
...

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


--
mjmoore