Need help for Row Data split

[Ram]

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

[binuacs]

@Ram One way of doing this, it is more dynamic

[Ram]

Thanks binuacs. I appreciate your help and support in this. Greatly helped me.