The "4" is referring to the number of source rows, not the number of cols.

If you have 32 cols but still 4 rows per col, its essentially the same
formula. But you should strip it down either starting in say, A6 (any row
below row 4). Or neater still, do it in another sheet.

Eg If the source data is in Sheet1,

In Sheet2,
Put in say, B1:
=OFFSET(Sheet1!$A$1,MOD(ROWS($1:1)-1,4),INT((ROWS($1:1)-1)/4))
then copy down until zeros appear signalling exhaustion of source data.

If you start in A6 in the same sheet as the source, just use the earlier
formula, and copy down as far as required.

Adjust the "4" in the formula to suit the number of source rows involved
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gaffnr" wrote:
thanks max. can confirm it works for 4 columns. What about if its 32 cols -
what part of the formula do i change? Ive tried the obvious one of 4 but it
didnt work
Really appreciate your help.
--
Rob Gaffney