How to Transpose (Columns to Rows) with a set of rows as columns.

[srknair]

I am trying to Transpose (Columns to Rows) with a set of rows are kept as columns. The image explains well.

Alter the left column like the table on right hand side!

[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl76, width: 64, align: right"]1[/TD]
[TD="class: xl77, width: 64"] [/TD]
[TD="class: xl78, width: 64, align: right"]1[/TD]
[TD="class: xl78, width: 64, align: right"]6[/TD]
[TD="class: xl78, width: 64, align: right"]11[/TD]
[TD="class: xl78, width: 64, align: right"]16[/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]2[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl78, align: right"]2[/TD]
[TD="class: xl78, align: right"]7[/TD]
[TD="class: xl78, align: right"]12[/TD]
[TD="class: xl78, align: right"]17[/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]3[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl78, align: right"]3[/TD]
[TD="class: xl78, align: right"]8[/TD]
[TD="class: xl78, align: right"]13[/TD]
[TD="class: xl78, align: right"]18[/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]4[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl78, align: right"]4[/TD]
[TD="class: xl78, align: right"]9[/TD]
[TD="class: xl78, align: right"]14[/TD]
[TD="class: xl78, align: right"]19[/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]5[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl78, align: right"]5[/TD]
[TD="class: xl78, align: right"]10[/TD]
[TD="class: xl78, align: right"]15[/TD]
[TD="class: xl78, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]6[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]7[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]8[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]9[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]10[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]11[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]12[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]13[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]14[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]15[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]16[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]17[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]18[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]19[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
[TR]
[TD="class: xl76, align: right"]20[/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[TD="class: xl77"] [/TD]
[/TR]
</tbody>[/TABLE]
How to do this?