Hi Everyone,
I have a requirement where i need to divide rows in a single column and obtain the following output.
A |
B |
C |
D |
E |
F |
G |
H |
I |
MATERIAL CODE |
MATERIAL DESCRIPTION |
PRODUCT |
BUDGET RM |
ACTUAL RM |
DEL QTY |
YIELD BUDGET |
YIELD ACTUAL |
YIELD ACTUAL FORMULA |
513010006 |
KETOCONAZOLE CRUDE |
KETOCONAZOLE |
4,323 |
4,379 |
50,968.000 |
1.064 |
1.078 |
F3/F4 |
513010035 |
KETOCONAZOLE PHARMA_MEOH |
KETOCONAZOLE |
53 |
72 |
47,300.500 |
1.000 |
1.000 |
F4/F4 |
513052016 |
PAROXETINE STAGE-II (DI BORANE) |
PAROXETINE |
4,778 |
4,615 |
14,287.200 |
2.455 |
0.576 |
F5/F6 |
513052017 |
PAROXETINE STAGE -3A (BORANE) |
PAROXETINE |
1,327 |
1,463 |
24,791.750 |
3.931 |
4.322 |
F6/F7 |
513052018 |
PAROXETINE STAGE -3B (BORANE) |
PAROXETINE |
3,270 |
3,037 |
5,736.820 |
1.000 |
1.000 |
F7/F7 |
In this I want to obtain the output which is present in the YIELD ACTUAL Column and formula for the same is been shown in the YIELD ACTUAL FORMULA Column.
Can anyone guide on how this can be done? Division needs to be done on the basis of PRODUCT.