ckotsis

I am assuming your input data are starting at A4. Your output starts at
F3. The formula in F3:

=OFFSET($A$4,(ROW()-ROW(F$3))*4+MOD(COLUMN()-COLUMN($F3),4),0)

Copy down and accross 4 columns.

HTH
Kostis Vezerides