Salamullah
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 221
Please help me to bring data from Horizontal array to vertical area.
<colgroup><col width="64" style="width: 48pt;" span="8">
<tbody>
</tbody>
Horizontal | |||||||
Volume | Profit | ||||||
Product | Jan | Feb | Mar | Jan | Feb | Mar | |
A | 10 | 40 | 70 | 120 | 520 | 1680 | |
B | 20 | 50 | 80 | 180 | 250 | 720 | |
C | 30 | 60 | 90 | 150 | 180 | 600 | |
Vertical | |||||||
Product | Month | Volume | Profit | ||||
A | Jan | 10 | 120 | ||||
B | Jan | 20 | 180 | ||||
C | Jan | 30 | 150 | ||||
A | Feb | 40 | 520 | ||||
B | Feb | 50 | 250 | ||||
C | Feb | 60 | 180 | ||||
A | Mar | 70 | 1680 | ||||
B | Mar | 80 | 720 | ||||
C | Mar | 90 | 600 |