Reg: Excel query

Respected Sir/Madam,

This is regarding a query that i have in MsEXCEL.

I would like to know is there any formula or script so that i can get the below output from the source.

Source:
--------------
Coloumn1 Coloumn2 Coloumn3 Coloumn4 Coloumn5 Coloumn6
AAAA 12/5/2011 zzz 1 hh rw
BBBB 12/1/2011 yyy 2 tt fg
CCCC 12/3/2011 xxx 3 rr hj
DDDD 11/29/2011 zzz 4 ss kl
EEEE 12/6/2011 yyy 5 ff as
FFFF 11/25/2011 yyy 6 ee we
GGGG 12/3/2011 xxx 7 yy rt
HHHH 12/4/2011 yyy 8 jj uio
IIII 12/1/2011 xxx 9 hh vb
JJJJ 11/30/2011 zzz 10 kk df

Output:
--------------
Coloumn1 Coloumn2 Coloumn3 Coloumn4 Coloumn5 Coloumn6
AAAA 12/5/2011 zzz 1 hh rw
BBBB 12/1/2011 yyy 2 tt fg
CCCC 12/3/2011 xxx 3 rr hj
EEEE 12/6/2011 yyy 5 ff as
GGGG 12/3/2011 xxx 7 yy rt
HHHH 12/4/2011 yyy 8 jj uio
IIII 12/1/2011 xxx 9 hh vb

Kindly provide the necessary solution, if any. Expecting a positive reply.
Thanks in advance.

Yours Faithfully,
Ajith