Urgently required the macro converting rows to columns

[adantul1]

1007A1

VTC

VLB9

a

b

c

d

g

h

i

j

k

2011

0

0

0

0

0

0

0

0

0

0

0

0

<COLGROUP><COL style="WIDTH: 48pt" span=26 width=64><TBODY>
</TBODY>

Hi i need the above sheet to be converted into following format in another sheet

1007A1
VTC
VLB9
a
b
c
d
g
h
i
j
k
2011
0
0
0
0
0
0
0
0
0
0
0
0

<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>

 

[sumantaimd]

You can use transpose method for your requirement. In the paste special menu it is available.