M
mzehr
Hi,
Assuming that your data is on Sheet1 and that your data
begins in Cell A1
In Sheet2 cell A1 insert the following formula
=OFFSET(Sheet1!$A$1,ROW()*3-4+COLUMN(),0)
and copy to columns A, B, C
and down until you run out of data
For additional help see:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
HTH
Assuming that your data is on Sheet1 and that your data
begins in Cell A1
In Sheet2 cell A1 insert the following formula
=OFFSET(Sheet1!$A$1,ROW()*3-4+COLUMN(),0)
and copy to columns A, B, C
and down until you run out of data
For additional help see:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
HTH