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