Forum Discussion

JakeRoper's avatar
JakeRoper
Copper Contributor
Feb 03, 2020
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 li...
  • Patrick2788's avatar
    Feb 03, 2020

    JakeRoper 

     

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

     

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

Resources