| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose column into rows for use as mailmerge data
I have data in the following format and would like to convert into an Excel
spreadsheet for use as mail merge database Mr Chris Acton ADH Services Ltd Unit 5 The Oaks Down End Crediton Devon EX17 1HN Mr Peter Alexander Mains Of Mause Blairgowrie Tayside PH10 6TE Mr James Anderson Bowmer & Kirkland Ltd High Edge Court Church Street Belper Derbyshire DE56 2BW If the addresses were only three lines then I could use the following method. However some addresses have 5, 6 or 7 lines. Can anybody help get it in the right format for a mailmerge? In B1 enter this formula =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:A)) Drag/copy across to D1. Select B1:D1 and drag/copy down until zeros show up. Select columns B:D and copy. EditPaste Special(in place)ValuesOKEsc Delete Column A -- Nash |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose every 10 cells in single column to multiple rows | Excel Discussion (Misc queries) | |||
| Transpose data from many horizontal rows into a single column | Excel Discussion (Misc queries) | |||
| Can you transpose 1 column into multiple rows creating a table | Excel Discussion (Misc queries) | |||
| Transpose Data from a column to several rows | Excel Worksheet Functions | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
Threaded Mode
