Dividing Rows in a single column of particular group
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.
