Copy cell groups whilst dragging values down column

[JakeRoper]

Hello,

I was wondering if it were possible to drag some row values down (copy) into some new rows, but in groups instead of singular?

For example,

So in the above example, I would like the group highlighted to be copied again, but with `Test 4` instead.

[#2 · Accepted solution]

@JakeRoper 

Try this. The 120 being how many rows you need to fill:

="Test "&INT(SEQUENCE(120,1,1,0.34))

[#3]

Thank you very much @Patrick2788 - I've edited the formula to add more rows/steps, but other than that, exactly what I wanted.

[#4]

@JakeRoper 

You're welcome.