Here is my spread sheet:

[![enter image description here](https://i.stack.imgur.com/yJAWE.png)](https://i.stack.imgur.com/yJAWE.png)

What I'm trying to do is break down my total weight into individual weights, to do this I have to make total weight absolute so I can multiply my % ratios. Only problem is some skus have 6 items some have 5 items so I can't just set every X rows make absolute. essentially I want to do this.

[![enter image description here](https://i.stack.imgur.com/sM51u.png)](https://i.stack.imgur.com/sM51u.png)

P.S. I have about 5000 rows so it'd take a really long time to manually do it. Wondering if there's any solutions thanks.