I'm struggling to figure this one out, hope you can help.
I have a unspecified amount of data in column B starting from cell 7 and data in row 1 starting from D . What I am trying to achieve is to copy C into another sheet for every time there is a value in row 1. Once the values in row 1 have been finished it need to copy the next value in B and paste all of the values in row 1 again. It needs to do this until column C is empty.
I've attached an example to help describe the scenario. Sheet one has the data, sheet2 is the output. As you can see y is coped for every x and repeated for the next x and so forth until no more data is in y.
I hope this makes a small bit of sense!