I thought someone would have asked this, and they may have, but I was not successful in finding the answer in Excel.
I have a large spreadsheet in rows that I would like to copy and convert to columns.
Example of what I have:
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Location[/TD]
[TD="width: 64"]Data 1[/TD]
[TD="width: 64"]Data 2[/TD]
[TD="width: 64"]Data 3[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Option 1[/TD]
[TD]Alt 2[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Option 1[/TD]
[TD]Alt 2[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Option 2[/TD]
[TD]Alt 4[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Option 3[/TD]
[TD]Alt 4[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Option 3[/TD]
[TD]Alt 5[/TD]
[TD]Other 2[/TD]
[/TR]
</tbody>[/TABLE]
What I would like to convert it to:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Location[/TD]
[TD="width: 64"]Data[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Option 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Option 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Option 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Option 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Option 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 2[/TD]
[/TR]
</tbody>[/TABLE]
Help! Thanks!!
I have a large spreadsheet in rows that I would like to copy and convert to columns.
Example of what I have:
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Location[/TD]
[TD="width: 64"]Data 1[/TD]
[TD="width: 64"]Data 2[/TD]
[TD="width: 64"]Data 3[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Option 1[/TD]
[TD]Alt 2[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Option 1[/TD]
[TD]Alt 2[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Option 2[/TD]
[TD]Alt 4[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Option 3[/TD]
[TD]Alt 4[/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Option 3[/TD]
[TD]Alt 5[/TD]
[TD]Other 2[/TD]
[/TR]
</tbody>[/TABLE]
What I would like to convert it to:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Location[/TD]
[TD="width: 64"]Data[/TD]
[/TR]
[TR]
[TD]Origin 1[/TD]
[TD]Option 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 2[/TD]
[TD]Option 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 3[/TD]
[TD]Option 2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 4[/TD]
[TD]Option 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Origin 5[/TD]
[TD]Option 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alt 5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Other 2[/TD]
[/TR]
</tbody>[/TABLE]
Help! Thanks!!