2d to 1d array conversion

[lfoitek]

having problems with 2d array conversion to 1d array.  for example there is a 2d array with the first row having 2 values of 5 and 7.
the next row has values 4, 6, and 8. looking like this

A    B
C    D     E

my problem is that when i try and convert to a 1d array using reshape array function, the output has an "empty" array value between the B and the C.  looking like this

A    B   "empty"  C   D    E

is there a way to eliminate the empty array and concatenate the strings to look like A   B   C   D   E.

Thank you

[systems_eng]

I think this is what you're looking for.

[jasonhill]

The array control will automagically resize the array if any row has more elements than any previous row.  So your array was really:

A B _
C D E

Where "_" is an empty string.  To remove the empty strings, you could use something like this:



I susspect that there is a clever way to do it with array to spreadsheet string and back, but I am not sure exactly how that would work.

Message Edited by jasonhill on 08-11-2006 04:23 PM

[lfoitek]

Thank you very much for the help.  the first solution works and i will try the second as well