One way ..

a row of 60 cells of data

Assume it's meant that source data is in a column
in say, A1:A60 in Sheet1

In Sheet2
--------
To extract into a 15R x 4C grid

Put in say, A1:
=INDEX(Sheet1!$A$1:$A$60,ROWS($A$1:A1)*4-4
+COLUMNS($A$1:A1))

Copy A1 across to D1, fill down to D15

In Sheet3
-------
To extract into a 4R x 15C grid

Put in say, A1:
=INDEX(Sheet1!$A$1:$A$60,ROWS($A$1:A1)*15-15
+COLUMNS($A$1:A1))

Copy A1 across to O1, fill down to O4

The above 2 options should cover <g
what is meant by:
.. a 4x15 array

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Glenn@stress" wrote in message
...
Using Excel 2002. I need to take a row of 60 cells of data and convert it
into a 4x15 array. Ideally, I would create the array on a separate
worksheet.