Forum Discussion
Solved
Copy cell groups whilst dragging values down column
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.
Try this. The 120 being how many rows you need to fill:
="Test "&INT(SEQUENCE(120,1,1,0.34))
3 Replies
Try this. The 120 being how many rows you need to fill:
="Test "&INT(SEQUENCE(120,1,1,0.34))
Thank you very much Patrick2788 - I've edited the formula to add more rows/steps, but other than that, exactly what I wanted.
You're welcome.
