andrea1982
New Member
- Joined
- Apr 13, 2017
- Messages
- 1

Does anyone knows how could I transpose 32,000 rows and stack several columns (same category, employees) in one column in the following way?
[TABLE="width: 435"]
<tbody>[TR]
[TD="class: xl63, width: 87, align: center"]Company[/TD]
[TD="class: xl63, width: 87, align: center"]Employee[/TD]
[TD="class: xl63, width: 87, align: center"]Employee[/TD]
[TD="class: xl63, width: 87, align: center"]Employee[/TD]
[TD="class: xl63, width: 87, align: center"]Employee[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]1[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="class: xl64, align: center"]B[/TD]
[TD="class: xl64, align: center"]C[/TD]
[TD="class: xl64, align: center"]D[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]2[/TD]
[TD="class: xl64, align: center"]D[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]3[/TD]
[TD="class: xl64, align: center"]E[/TD]
[TD="class: xl64, align: center"]F[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="class: xl64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]…[/TD]
[TD="class: xl64, align: center"]…[/TD]
[TD="class: xl64, align: center"]…[/TD]
[TD="class: xl64, align: center"]…[/TD]
[TD="class: xl64, align: center"]…[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]32,000[/TD]
[TD="class: xl64, align: center"]F[/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[/TR]
</tbody>[/TABLE]
to
[TABLE="width: 174"]
<tbody>[TR]
[TD="class: xl63, width: 87, align: center"]Company[/TD]
[TD="class: xl63, width: 87, align: center"]Employee[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]1[/TD]
[TD="class: xl63, align: center"]A[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]1[/TD]
[TD="class: xl63, align: center"]B[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]1[/TD]
[TD="class: xl63, align: center"]C[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]1[/TD]
[TD="class: xl63, align: center"]D[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]2[/TD]
[TD="class: xl63, align: center"]D[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]2[/TD]
[TD="class: xl63, align: center"]A[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]3[/TD]
[TD="class: xl63, align: center"]E[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]3[/TD]
[TD="class: xl63, align: center"]F[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]3[/TD]
[TD="class: xl63, align: center"]A[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]…[/TD]
[TD="class: xl64, align: center"]…[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]32000[/TD]
[TD="class: xl64, align: center"]F[/TD]
[/TR]
</tbody>[/TABLE]
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore

