| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transpose 1 column of 100 items to 10 x 10 array
I frequently copy data into EXCEL that comes in as a column of data, but
needs to be put in an array to mail merge ect. ie. name, address, city, zip repeated for a hundred names in column A, needs to go into an array 4 columns wide and 20 rows deep. thanks in advance, rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I transpose items from another sheet? | Excel Discussion (Misc queries) | |||
| Transpose array sum | Excel Worksheet Functions | |||
| transpose - array problem | Excel Discussion (Misc queries) | |||
| Transpose Array | Excel Discussion (Misc queries) | |||
| Conditional transpose to Array | Excel Discussion (Misc queries) | |||
Threaded Mode
