Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list, i.e. a one dimensional array, of numbers. I want to
insert 9 blanks between each cell that has a number in it. Is there a simple way to do this? Or in the alternative, is there an easy way to convert a two dimensional array into a one dimensional array (that is, for my purposes, to insert a 9 blank rows below my one dimensional array of data & then convert it to a one dimensional array, thereby leaving nine blanks between each filled cell)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
font size auto changing from 11 to 15.5 when inserting a symbol | Excel Discussion (Misc queries) | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
Weighed average if the adjecent column contains blanks | Excel Discussion (Misc queries) | |||
linking files with blanks | Excel Discussion (Misc queries) | |||
Filling in blanks. | Excel Worksheet Functions |