OK then, say your 1D is in A1:A12, and also say that you want to
produce a 4row-3col output. We are interested in the number 3. If your
2D starts at C1 then use the following formula:

=INDEX($A$1:$A$12,(ROW()-ROW($C$1))*3+COLUMN()-COLUMN($C$1)+1)

HTH
Kostis

On Jan 26, 8:05 pm, "James Silverton"
wrote:
"vezerid" wrote in glegroups.com...

James,
what do you mean exactly? Generating an array constant from a
range? Or
take a 1-dimensional array and create a 2-dimensional from
this?

HTH
Kostis VezeridesThanks for the quick feed-back! It's the latter; I was using
column and 1-d array as synonyms.

--
James Silverton
Potomac, Maryland