Hi!

Assume the data on sheet1 is in the range A1:BH1

On sheet2 enter this formula:

=INDEX(Sheet1!$A$1:$BH$1,(ROW(1:1)-1)*15+COLUMN(A1))

Copy across 15 columns then down 4 rows.

Biff

"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.