A 1
A 2
A 3
A 4

The previous formula for col F presumes you want it joined (i.e.: "A1",
"A2", etc) all in one col. If you want it split into 2 cols, just "split"
the formula, viz.:

Put in F1:
=OFFSET($A$1,INT((ROWS($A$1:A1)-1)/4),)

Put in G1:
=OFFSET($B$1,INT((ROWS($A$1:A1)-1)/4),MOD(ROWS($A$1:A1)-1,4))

Then select F1:G1 and copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--