Transpose rows to column for fixed template

[sonkar]

Hi,

I have large set of data to convert rows into columns as per below template
existing data.Also is it possible to have new sheet when the current sheet is full.[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Header1[/TD]
[TD="width: 64"]Header2[/TD]
[TD="width: 64"]Header3[/TD]
[TD="width: 64"]Header4[/TD]
[TD="width: 64"]Header5[/TD]
[TD="width: 64"]…..[/TD]
[TD="width: 64"]Header 80[/TD]
[/TR]
[TR]
[TD]data 1[/TD]
[TD]Data 2[/TD]
[TD]Data 3[/TD]
[TD]Data 4[/TD]
[TD]data 5[/TD]
[TD][/TD]
[TD]data 80[/TD]
[/TR]
</tbody>[/TABLE]

Required Data
[TABLE="width: 225"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Header1[/TD]
[TD]Data 1[/TD]
[TD]data 1[/TD]
[/TR]
[TR]
[TD]Header2[/TD]
[TD]Data 1[/TD]
[TD]Data 2[/TD]
[/TR]
[TR]
[TD]Header3[/TD]
[TD]Data 1[/TD]
[TD]Data 3[/TD]
[/TR]
[TR]
[TD]Header4[/TD]
[TD]Data 1[/TD]
[TD]Data 4[/TD]
[/TR]
[TR]
[TD]Header5[/TD]
[TD]Data 1[/TD]
[TD]data 5[/TD]
[/TR]
[TR]
[TD]…..[/TD]
[TD]Data 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Header 80[/TD]
[TD]Data 1[/TD]
[TD]data 80[/TD]
[/TR]
</tbody>[/TABLE]

Thanks
sachin

 

[CyrusTheVirus]

Highlight the whole section, then copy selection, then click a few cells below range, then press Alt, e, s, e (transpose) and then enter.

 

[sonkar]

Highlight the whole section, then copy selection, then click a few cells below range, then press Alt, e, s, e (transpose) and then enter.

Hi,

the data is not in single row,I have multiple rows and each row should come one below the other and i have more than 10,000 rows of dat to be converted in same format
[TABLE="width: 250"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Header1[/TD]
[TD]A[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Header2[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Header3[/TD]
[TD]A[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Header4[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Header5[/TD]
[TD]A[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Header 80[/TD]
[TD]A[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]Header1[/TD]
[TD]P[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]Header2[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[/TR]
[TR]
[TD]Header3[/TD]
[TD]P[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]Header4[/TD]
[TD]P[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]Header5[/TD]
[TD]P[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]Header 80[/TD]
[TD]P[/TD]
[TD]U[/TD]
[/TR]
</tbody>[/TABLE]

Thanks
Sachin