Transpose Mailing List to Columns
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 |
Transpose Mailing List to Columns
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 |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com