Type of loop to expand and add

[earlyfreak]

Don't know the best way to start this. I am thinking maybe with a loop, add and expand rows and then values. Any direction would be appreciated


VBA to expand.png