Max,
Actually, it wasn't a typo. Your version captured the entire table. Mine
only started after the first column of 30 cells, A1:A30, picking up the
remaining (column B and on), putting it starting in A31. A1:A30 would
remain. Just a little lazy. My intent was to use the formulas to grab
columns B:AD, and delete them after the formula cells had been converted to
hard values with paste special - values. Lotsa ways to git 'r done (Larry
the cable guy).
--
Earl Kiosterud
www.smokeylake.com
"Max" wrote in message
...
"Earl Kiosterud" wrote
...
Put this in A31, and copy down.
=OFFSET(A31,-(INT((ROW()-1)/30))*30,INT((ROW()-1)/30),1,1)
Much neater, Earl !
Perhaps with just a typo corrected, in A31, copied down to A1530:
=OFFSET(A31,-(INT((ROW()-1)/30))*30,INT((ROW()-1)/30)-1,1,1)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--