Qwerky script required

  • Hi,

    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!

    TIA
    John

  • How about

  • How about

  • How about, this assumes that cols C:D are empty.