| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manipulating a column array into different cell locations
I have a long list of 400 names in a column array A1:A400
I want to "double space" this data. That is, introduce a blank row after each name in the column in order to get a new array that now contains the same data spaced out in B1 B3 B5 ....etc....B800 Is there an easy way to do it without dragging and dropping 400 times? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFill pattern based on cell locations | Excel Discussion (Misc queries) | |||
| Changing cell locations with formula? | Excel Discussion (Misc queries) | |||
| InputBox to select cell locations | Excel Worksheet Functions | |||
| Manipulating Cell Contents? | Excel Discussion (Misc queries) | |||
| Filling excel entire row/column instead of single cell from an array | Excel Worksheet Functions | |||
Threaded Mode
