Transpose Mailing List to Columns

M

mjmoore

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
 
D

Daniel CHEN

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
==================================
 
Top