Feb 03 2020 08:04 AM
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.
Feb 03 2020 08:30 AM
Solution
Try this. The 120 being how many rows you need to fill:
="Test "&INT(SEQUENCE(120,1,1,0.34))
Feb 03 2020 08:36 AM
Thank you very much @Patrick2788 - I've edited the formula to add more rows/steps, but other than that, exactly what I wanted.
Feb 03 2020 08:38 AM
You're welcome.
Feb 03 2020 08:30 AM
Solution
Try this. The 120 being how many rows you need to fill:
="Test "&INT(SEQUENCE(120,1,1,0.34))