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.

Header1	Header2	Header3	Header4	Header5	…..	Header 80
data 1	Data 2	Data 3	Data 4	data 5		data 80

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

Required Data

Header1	Data 1	data 1
Header2	Data 1	Data 2
Header3	Data 1	Data 3
Header4	Data 1	Data 4
Header5	Data 1	data 5
…..	Data 1
Header 80	Data 1	data 80

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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

Header1	A	A
Header2	A	B
Header3	A	C
Header4	A	D
Header5	A	E
Header 80	A	F
Header1	P	P
Header2	P	Q
Header3	P	R
Header4	P	S
Header5	P	T
Header 80	P	U

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thanks
Sachin