silverdollar
New Member
- Joined
- May 11, 2017
- Messages
- 2
Hello,
I have a set of data that contains data using a combination of columns and rows. I would like to transpose the columns into the rows so I would be able to create a load file. I'm not quite sure how to explain this but please see the screen print below to see what I am trying to accomplish. The actual data set has over 200 rows and 200 columns, the end result would have roughly 40,000 (200*200) rows of data. If anyone has a good suggestion on creating this data set, please let me know. I would appreciate any suggestions. Thanks everyone!!
[TABLE="width: 260"]
<tbody>[TR]
[TD="class: xl64, width: 65"]BEFORE:[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="class: xl63, align: right"]Unit A[/TD]
[TD="class: xl63, align: right"]Unit B[/TD]
[TD="class: xl63, align: right"]Unit C[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-100[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="align: right"]-400[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]-100[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]300[/TD]
[/TR]
</tbody>[/TABLE]
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</style><![endif]-->[TABLE="width: 195"]
<tbody>[TR]
[TD="class: xl66, width: 65"]AFTER:[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Account[/TD]
[TD="class: xl64, align: center"]Unit[/TD]
[TD="class: xl64, align: right"]Amount[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]-400[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]-100[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]-100[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]300[/TD]
[/TR]
</tbody>[/TABLE]
I have a set of data that contains data using a combination of columns and rows. I would like to transpose the columns into the rows so I would be able to create a load file. I'm not quite sure how to explain this but please see the screen print below to see what I am trying to accomplish. The actual data set has over 200 rows and 200 columns, the end result would have roughly 40,000 (200*200) rows of data. If anyone has a good suggestion on creating this data set, please let me know. I would appreciate any suggestions. Thanks everyone!!
[TABLE="width: 260"]
<tbody>[TR]
[TD="class: xl64, width: 65"]BEFORE:[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="class: xl63, align: right"]Unit A[/TD]
[TD="class: xl63, align: right"]Unit B[/TD]
[TD="class: xl63, align: right"]Unit C[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-100[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="align: right"]-400[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]-100[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]300[/TD]
[/TR]
</tbody>[/TABLE]
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</style><![endif]-->[TABLE="width: 195"]
<tbody>[TR]
[TD="class: xl66, width: 65"]AFTER:[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Account[/TD]
[TD="class: xl64, align: center"]Unit[/TD]
[TD="class: xl64, align: right"]Amount[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]-400[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="class: xl63"]Unit A[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]-100[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="class: xl63"]Unit B[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]GL-1000[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]GL-1001[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]GL-2000[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]-100[/TD]
[/TR]
[TR]
[TD]GL-2002[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]GL-3000[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]GL-3001[/TD]
[TD="class: xl63"]Unit C[/TD]
[TD="align: right"]300[/TD]
[/TR]
</tbody>[/TABLE]