Salamullah
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 221
Hi,
I have month wise data Horizontally which I want to bring vertically with formula, please help.
Horizontal Vertical
<tbody>
</tbody><colgroup><col><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col><col><col><col><col><col><col></colgroup>
I have month wise data Horizontally which I want to bring vertically with formula, please help.
Horizontal Vertical
Volume | Sales | Cost | Profit | Product | Area | Month | Volume | Sales | Cost | Profit | ||||||||||||||
Product | Area | Jan | Feb | Mar | Jan | Feb | Mar | Jan | Feb | Mar | Jan | Feb | Mar | |||||||||||
A | BLACK | 200 | 300 | 151 | 19,000 | 28,500 | 14,345 | 2,500 | 7,500 | 3,775 | 16,500 | 21,000 | 10,570 | A | BLACK | Jan | 200 | 19,000 | 2,500 | 16,500 | ||||
B | BLACK | 220 | 315 | 171 | 20,900 | 29,925 | 16,245 | 3,000 | 7,875 | 4,275 | 17,900 | 22,050 | 11,970 | B | BLACK | Jan | 220 | 20,900 | 3,000 | 17,900 | ||||
C | RED | 240 | 330 | 191 | 22,800 | 31,350 | 18,145 | 3,500 | 8,250 | 4,775 | 19,300 | 23,100 | 13,370 | C | RED | Jan | 240 | 22,800 | 3,500 | 19,300 | ||||
E | GREEN | 260 | 345 | 211 | 24,700 | 32,775 | 20,045 | 4,000 | 8,625 | 5,275 | 20,700 | 24,150 | 14,770 | E | GREEN | Jan | 260 | 24,700 | 4,000 | 20,700 | ||||
D | GREEN | 280 | 360 | 231 | 26,600 | 34,200 | 21,945 | 4,500 | 9,000 | 5,775 | 22,100 | 25,200 | 16,170 | D | GREEN | Jan | 280 | 26,600 | 4,500 | 22,100 | ||||
A | BLUE | 300 | 375 | 251 | 28,500 | 35,625 | 23,845 | 5,000 | 9,375 | 6,275 | 23,500 | 26,250 | 17,570 | A | BLUE | Jan | 300 | 28,500 | 5,000 | 23,500 | ||||
A | GREEN | 320 | 390 | 271 | 30,400 | 37,050 | 25,745 | 5,500 | 9,750 | 6,775 | 24,900 | 27,300 | 18,970 | A | GREEN | Jan | 320 | 30,400 | 5,500 | 24,900 | ||||
Total | 1,820 | 2,415 | 1,477 | 172,900 | 229,425 | 140,315 | 28,000 | 60,375 | 36,925 | 144,900 | 169,050 | 103,390 | A | BLACK | Feb | 300 | 28,500 | 7,500 | 21,000 | |||||
417,340 | B | BLACK | Feb | 315 | 29,925 | 7,875 | 22,050 | |||||||||||||||||
C | RED | Feb | 330 | 31,350 | 8,250 | 23,100 | ||||||||||||||||||
E | GREEN | Feb | 345 | 32,775 | 8,625 | 24,150 | ||||||||||||||||||
D | GREEN | Feb | 360 | 34,200 | 9,000 | 25,200 | ||||||||||||||||||
A | BLUE | Feb | 375 | 35,625 | 9,375 | 26,250 | ||||||||||||||||||
A | GREEN | Feb | 390 | 37,050 | 9,750 | 27,300 | ||||||||||||||||||
A | BLACK | Mar | 151 | 14,345 | 3,775 | 10,570 | ||||||||||||||||||
B | BLACK | Mar | 171 | 16,245 | 4,275 | 11,970 | ||||||||||||||||||
C | RED | Mar | 191 | 18,145 | 4,775 | 13,370 | ||||||||||||||||||
E | GREEN | Mar | 211 | 20,045 | 5,275 | 14,770 | ||||||||||||||||||
D | GREEN | Mar | 231 | 21,945 | 5,775 | 16,170 | ||||||||||||||||||
A | BLUE | Mar | 251 | 23,845 | 6,275 | 17,570 | ||||||||||||||||||
A | GREEN | Mar | 271 | 25,745 | 6,775 | 18,970 | ||||||||||||||||||
417,340 | ||||||||||||||||||||||||
<tbody>
</tbody><colgroup><col><col><col span="3"><col><col span="3"><col><col span="3"><col><col span="3"><col><col><col><col><col><col><col><col></colgroup>