Grouping Rows to Create a Value

Hi all,

I’ve been working on a problem for far too long and need some assistance please. I can’t find what I’m looking for on the forums, and frankly, I’ve been scratching my head for too long.

Below is an example of what I’m trying to achieve…

I’ve tried various loops with counter generation but can’t seem to work it out.

I feel it’s a simple problem and I can’t see the wood through the trees!

Thank you for any tips and advice.

Cheers.