how can I transpose the info in EXCEL from....to
[TABLE="width: 832"]
<colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
FROM excel in tab 1
[/TD]
[TD="colspan: 13"][/TD]
[/TR]
[TR]
[TD]code[/TD]
[TD]product[/TD]
[TD]Jan[/TD]
[TD]feb [/TD]
[TD]Mar[/TD]
[TD]April[/TD]
[TD]May [/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]Sept[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]49471[/TD]
[TD="align: right"]45847[/TD]
[TD="align: right"]53911[/TD]
[TD="align: right"]50423[/TD]
[TD="align: right"]53134[/TD]
[TD="align: right"]52702[/TD]
[TD="align: right"]48510[/TD]
[TD="align: right"]47344[/TD]
[TD="align: right"]49265[/TD]
[TD="align: right"]51504[/TD]
[TD="align: right"]51333[/TD]
[TD="align: right"]48554[/TD]
[/TR]
[TR]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]123185[/TD]
[TD="align: right"]114161[/TD]
[TD="align: right"]134241[/TD]
[TD="align: right"]125555[/TD]
[TD="align: right"]132307[/TD]
[TD="align: right"]131231[/TD]
[TD="align: right"]120791[/TD]
[TD="align: right"]117887[/TD]
[TD="align: right"]122671[/TD]
[TD="align: right"]128248[/TD]
[TD="align: right"]127822[/TD]
[TD="align: right"]120901[/TD]
[/TR]
[TR]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]74289[/TD]
[TD="align: right"]68847[/TD]
[TD="align: right"]80956[/TD]
[TD="align: right"]75718[/TD]
[TD="align: right"]79790[/TD]
[TD="align: right"]79141[/TD]
[TD="align: right"]72845[/TD]
[TD="align: right"]71094[/TD]
[TD="align: right"]73979[/TD]
[TD="align: right"]77342[/TD]
[TD="align: right"]77085[/TD]
[TD="align: right"]72912[/TD]
[/TR]
[TR]
[TD="align: right"]31012582[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]111516[/TD]
[TD="align: right"]103347[/TD]
[TD="align: right"]121524[/TD]
[TD="align: right"]113661[/TD]
[TD="align: right"]119773[/TD]
[TD="align: right"]118799[/TD]
[TD="align: right"]109348[/TD]
[TD="align: right"]106720[/TD]
[TD="align: right"]111051[/TD]
[TD="align: right"]116099[/TD]
[TD="align: right"]115713[/TD]
[TD="align: right"]109449[/TD]
[/TR]
[TR]
[TD="align: right"]31014216[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]24243[/TD]
[TD="align: right"]22467[/TD]
[TD="align: right"]26418[/TD]
[TD="align: right"]24709[/TD]
[TD="align: right"]26038[/TD]
[TD="align: right"]25826[/TD]
[TD="align: right"]23771[/TD]
[TD="align: right"]23200[/TD]
[TD="align: right"]24141[/TD]
[TD="align: right"]25239[/TD]
[TD="align: right"]25155[/TD]
[TD="align: right"]23793[/TD]
[/TR]
[TR]
[TD="align: right"]31014216[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]57607[/TD]
[TD="align: right"]53387[/TD]
[TD="align: right"]62777[/TD]
[TD="align: right"]58715[/TD]
[TD="align: right"]61873[/TD]
[TD="align: right"]61369[/TD]
[TD="align: right"]56487[/TD]
[TD="align: right"]55129[/TD]
[TD="align: right"]57367[/TD]
[TD="align: right"]59974[/TD]
[TD="align: right"]59775[/TD]
[TD="align: right"]56539[/TD]
[/TR]
</tbody>[/TABLE]
To tab 2
[TABLE="width: 301"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]code [/TD]
[TD] product[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]49471[/TD]
[/TR]
[TR]
[TD]feb [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]45847[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]53911[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]50423[/TD]
[/TR]
[TR]
[TD]May [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]53134[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]52702[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]48510[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]47344[/TD]
[/TR]
[TR]
[TD]Sept[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]49265[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]51504[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]51333[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]48554[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]123185[/TD]
[/TR]
[TR]
[TD]feb [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]114161[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]134241[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]125555[/TD]
[/TR]
[TR]
[TD]May [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]132307[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]131231[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]120791[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]117887[/TD]
[/TR]
[TR]
[TD]Sept[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]122671[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]128248[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]127822[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]120901[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]74289[/TD]
[/TR]
[TR]
[TD]feb [/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]68847[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]80956[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]75718[/TD]
[/TR]
[TR]
[TD]May [/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]79790[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]79141[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]72845[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]71094[/TD]
[/TR]
</tbody>[/TABLE]
etc
etc
[TABLE="width: 832"]
<colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]
FROM excel in tab 1
[/TD]
[TD="colspan: 13"][/TD]
[/TR]
[TR]
[TD]code[/TD]
[TD]product[/TD]
[TD]Jan[/TD]
[TD]feb [/TD]
[TD]Mar[/TD]
[TD]April[/TD]
[TD]May [/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]Sept[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]49471[/TD]
[TD="align: right"]45847[/TD]
[TD="align: right"]53911[/TD]
[TD="align: right"]50423[/TD]
[TD="align: right"]53134[/TD]
[TD="align: right"]52702[/TD]
[TD="align: right"]48510[/TD]
[TD="align: right"]47344[/TD]
[TD="align: right"]49265[/TD]
[TD="align: right"]51504[/TD]
[TD="align: right"]51333[/TD]
[TD="align: right"]48554[/TD]
[/TR]
[TR]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]123185[/TD]
[TD="align: right"]114161[/TD]
[TD="align: right"]134241[/TD]
[TD="align: right"]125555[/TD]
[TD="align: right"]132307[/TD]
[TD="align: right"]131231[/TD]
[TD="align: right"]120791[/TD]
[TD="align: right"]117887[/TD]
[TD="align: right"]122671[/TD]
[TD="align: right"]128248[/TD]
[TD="align: right"]127822[/TD]
[TD="align: right"]120901[/TD]
[/TR]
[TR]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]74289[/TD]
[TD="align: right"]68847[/TD]
[TD="align: right"]80956[/TD]
[TD="align: right"]75718[/TD]
[TD="align: right"]79790[/TD]
[TD="align: right"]79141[/TD]
[TD="align: right"]72845[/TD]
[TD="align: right"]71094[/TD]
[TD="align: right"]73979[/TD]
[TD="align: right"]77342[/TD]
[TD="align: right"]77085[/TD]
[TD="align: right"]72912[/TD]
[/TR]
[TR]
[TD="align: right"]31012582[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]111516[/TD]
[TD="align: right"]103347[/TD]
[TD="align: right"]121524[/TD]
[TD="align: right"]113661[/TD]
[TD="align: right"]119773[/TD]
[TD="align: right"]118799[/TD]
[TD="align: right"]109348[/TD]
[TD="align: right"]106720[/TD]
[TD="align: right"]111051[/TD]
[TD="align: right"]116099[/TD]
[TD="align: right"]115713[/TD]
[TD="align: right"]109449[/TD]
[/TR]
[TR]
[TD="align: right"]31014216[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]24243[/TD]
[TD="align: right"]22467[/TD]
[TD="align: right"]26418[/TD]
[TD="align: right"]24709[/TD]
[TD="align: right"]26038[/TD]
[TD="align: right"]25826[/TD]
[TD="align: right"]23771[/TD]
[TD="align: right"]23200[/TD]
[TD="align: right"]24141[/TD]
[TD="align: right"]25239[/TD]
[TD="align: right"]25155[/TD]
[TD="align: right"]23793[/TD]
[/TR]
[TR]
[TD="align: right"]31014216[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]57607[/TD]
[TD="align: right"]53387[/TD]
[TD="align: right"]62777[/TD]
[TD="align: right"]58715[/TD]
[TD="align: right"]61873[/TD]
[TD="align: right"]61369[/TD]
[TD="align: right"]56487[/TD]
[TD="align: right"]55129[/TD]
[TD="align: right"]57367[/TD]
[TD="align: right"]59974[/TD]
[TD="align: right"]59775[/TD]
[TD="align: right"]56539[/TD]
[/TR]
</tbody>[/TABLE]
To tab 2
[TABLE="width: 301"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]code [/TD]
[TD] product[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]49471[/TD]
[/TR]
[TR]
[TD]feb [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]45847[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]53911[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]50423[/TD]
[/TR]
[TR]
[TD]May [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]53134[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]52702[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]48510[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]47344[/TD]
[/TR]
[TR]
[TD]Sept[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]49265[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]51504[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]51333[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]48554[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]123185[/TD]
[/TR]
[TR]
[TD]feb [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]114161[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]134241[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]125555[/TD]
[/TR]
[TR]
[TD]May [/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]132307[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]131231[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]120791[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]117887[/TD]
[/TR]
[TR]
[TD]Sept[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]122671[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]128248[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]127822[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD="align: right"]31010054[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]120901[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]74289[/TD]
[/TR]
[TR]
[TD]feb [/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]68847[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]80956[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]75718[/TD]
[/TR]
[TR]
[TD]May [/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]79790[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]79141[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]72845[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD="align: right"]31012582[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]71094[/TD]
[/TR]
</tbody>[/TABLE]
etc
etc