| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address Transposing
Hope you can help. I have a number of spreadsheets containing customer details and addresses. The details for each customer are contained in a single row, but the addresses read in a single column,eg.
Name | ID | Address | Org. | Currency | __________________________________________________ _ J.Doe | 23 |101 Easy Street | 5221 | Euro | |Nowhere Lane | |Deadville | Some addresses are longer than others. I can move the Address column to the end of the spreadsheet to prevent misplacing the Org. and Currency. The spacing between each customer varies, between 1 and 10 blank rows. Some code i have tried requires fixed spacing. Can you suggest some code that will allow me to move the rest of the address into the same row? I have to do this for nearly 18,000 customers!! Submitted via EggHeadCafe - Software Developer Portal of Choice Job Interview And Resume Tips for Developers http://www.eggheadcafe.com/tutorials...nd-resume.aspx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Address Transposing
Did you want the address to end up in a single cell or in several cells
across several columns (one for each row used)? -- Rick (MVP - Excel) "Barry Freeman" wrote in message ... Hope you can help. I have a number of spreadsheets containing customer details and addresses. The details for each customer are contained in a single row, but the addresses read in a single column,eg. Name | ID | Address | Org. | Currency | __________________________________________________ _ J.Doe | 23 |101 Easy Street | 5221 | Euro | |Nowhere Lane | |Deadville | Some addresses are longer than others. I can move the Address column to the end of the spreadsheet to prevent misplacing the Org. and Currency. The spacing between each customer varies, between 1 and 10 blank rows. Some code i have tried requires fixed spacing. Can you suggest some code that will allow me to move the rest of the address into the same row? I have to do this for nearly 18,000 customers!! Submitted via EggHeadCafe - Software Developer Portal of Choice Job Interview And Resume Tips for Developers http://www.eggheadcafe.com/tutorials...nd-resume.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing an Address List | Excel Discussion (Misc queries) | |||
| 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) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming | |||
Linear Mode
