Forum Discussion
JakeRoper
Feb 03, 2020Copper Contributor
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 li...
- Feb 03, 2020
Try this. The 120 being how many rows you need to fill:
="Test "&INT(SEQUENCE(120,1,1,0.34))
Patrick2788
Feb 03, 2020Silver Contributor
Try this. The 120 being how many rows you need to fill:
="Test "&INT(SEQUENCE(120,1,1,0.34))
- JakeRoperFeb 03, 2020Copper Contributor
Thank you very much Patrick2788 - I've edited the formula to add more rows/steps, but other than that, exactly what I wanted.
- Patrick2788Feb 03, 2020Silver Contributor
You're welcome.