rows to columns

[dvnr_76]

I want to convert a bloack of rows to columns

1 a b c 2 x y z 3 m n q
4 e f g 5 k l m 6 r s t


required format
1 a b c
4 e f g
2 x y z
5 k l m
3 m n q
6 r s t

[Ace_XL]

Like this..?

[dvnr_76]

Thanks a lot thats great but if i want the data to be placed(after applying the formula) in sheet2 what to do