Cust ID | Product | Score | Add On |
2345 | CO | 4.3 | 1.25 |
2345 | PD | 1.8 | 1.25 |
2345 | SP | 0.25 | |
2345 | AU | 0.1 | |
2345 | VS | 0.1 | |
2345 | CO+PD | 2.5 |
Wanted to know how CO+PD Score 2.5 can be split equally to the products CO, PD as the value should added in a separate column as Add on the end result should be like below
Cust ID | Product | Score |
2345 | CO | 5.55 |
2345 | PD | 3.05 |
2345 | SP | 0.25 |
2345 | AU | 0.1 |
2345 | VS | 0.1 |
Thanks binuacs. I appreciate your help and support in this. Greatly helped me.