I'm having difficulty reorganizing a set of tables and their columns within. I currently have close to 14K rows of data. As simple as it sounds, I cannot seem to find a fix to go from its vertical layout to a horizontal. Your help would be much appreciated. Below is an example of what my data currently looks like and the next example is what I hope to achieve. Needless to say I made the data rather generic in the examples.
[TABLE="class: grid, width: 238"]
<tbody>[TR]
[TD="align: center"]table_name[/TD]
[TD="align: center"]column_name[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 6[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 6[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 7[/TD]
[/TR]
</tbody>[/TABLE]
Hopeful Outcome
[TABLE="class: grid, width: 357"]
<tbody>[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADR[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 1[/TD]
[TD="align: center"]ADJ Column 1[/TD]
[TD="align: center"]ADR Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 2[/TD]
[TD="align: center"]ADJ Column 2[/TD]
[TD="align: center"]ADR Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 3[/TD]
[TD="align: center"]ADJ Column 3[/TD]
[TD="align: center"]ADR Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 4[/TD]
[TD="align: center"]ADJ Column 4[/TD]
[TD="align: center"]ADR Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 5[/TD]
[TD="align: center"]ADJ Column 5[/TD]
[TD="align: center"]ADR Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 6[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ADR Column 6[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ADR Column 7[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 238"]
<tbody>[TR]
[TD="align: center"]table_name[/TD]
[TD="align: center"]column_name[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]STS Column 6[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADJ Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 6[/TD]
[/TR]
[TR]
[TD="align: center"]ADR[/TD]
[TD="align: center"]ADR Column 7[/TD]
[/TR]
</tbody>[/TABLE]
Hopeful Outcome
[TABLE="class: grid, width: 357"]
<tbody>[TR]
[TD="align: center"]STS[/TD]
[TD="align: center"]ADJ[/TD]
[TD="align: center"]ADR[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 1[/TD]
[TD="align: center"]ADJ Column 1[/TD]
[TD="align: center"]ADR Column 1[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 2[/TD]
[TD="align: center"]ADJ Column 2[/TD]
[TD="align: center"]ADR Column 2[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 3[/TD]
[TD="align: center"]ADJ Column 3[/TD]
[TD="align: center"]ADR Column 3[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 4[/TD]
[TD="align: center"]ADJ Column 4[/TD]
[TD="align: center"]ADR Column 4[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 5[/TD]
[TD="align: center"]ADJ Column 5[/TD]
[TD="align: center"]ADR Column 5[/TD]
[/TR]
[TR]
[TD="align: center"]STS Column 6[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ADR Column 6[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]ADR Column 7[/TD]
[/TR]
</tbody>[/TABLE]