| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transposing an Address List
I have a 30k line address list that looks like this:
Customer #1 ATTN: ACCOUNTS PAYABLE Street Address, SUITE B CITY, STATE ZIP CODE Customer #2 Street Address City, State ATTN: ACCOUNTS PAYABLE Zip Code I need to move all the information from one column to 5 (transpose the info so that all the names are in one column, cities in another, etc.). Does anyone know how I can do that without copying and pasting each address? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
| Transpose list of address into rows for mailing list | Excel Discussion (Misc queries) | |||
| Transposing list of numbers | New Users to Excel | |||
| Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D | Excel Worksheet Functions | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
Threaded Mode
