Urgently required the macro converting rows to columns

[adantul1]

[TABLE="width: 1248"]
<COLGROUP><COL style="WIDTH: 48pt" span=26 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent, align: left"][/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]1007A1[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]VTC[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]VLB9[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]a[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]b[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]c[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]d[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]g[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]h[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]i[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]j[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]k[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]2011[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent, align: left"]0[/TD]
[/TR]
</TBODY>[/TABLE]

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


[TABLE="width: 48"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>[TR]
[TD="class: xl67, width: 64, bgcolor: transparent, align: left"]1007A1[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]VTC[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]VLB9[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]a[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]b[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]c[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]d[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]g[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]h[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]i[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]j[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: left"]k[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]2011[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]0[/TD]
[/TR]
</TBODY>[/TABLE]

 

[sumantaimd]

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