SOLVED

Copy cell groups whilst dragging values down column

%3CLINGO-SUB%20id%3D%22lingo-sub-1148090%22%20slang%3D%22en-US%22%3ECopy%20cell%20groups%20whilst%20dragging%20values%20down%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1148090%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20wondering%20if%20it%20were%20possible%20to%20drag%20some%20row%20values%20down%20(copy)%20into%20some%20new%20rows%2C%20but%20in%20groups%20instead%20of%20singular%3F%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168600i86E38C4FDF5B910E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3ESo%20in%20the%20above%20example%2C%20I%20would%20like%20the%20group%20highlighted%20to%20be%20copied%20again%2C%20but%20with%20%60Test%204%60%20instead.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1148090%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1148154%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20cell%20groups%20whilst%20dragging%20values%20down%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1148154%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F543326%22%20target%3D%22_blank%22%3E%40JakeRoper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this.%20The%20120%20being%20how%20many%20rows%20you%20need%20to%20fill%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%22Test%20%22%26amp%3BINT(SEQUENCE(%3CSTRONG%3E120%3C%2FSTRONG%3E%2C1%2C1%2C0.34))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1148171%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20cell%20groups%20whilst%20dragging%20values%20down%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1148171%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3B-%20I've%20edited%20the%20formula%20to%20add%20more%20rows%2Fsteps%2C%20but%20other%20than%20that%2C%20exactly%20what%20I%20wanted.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1148181%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20cell%20groups%20whilst%20dragging%20values%20down%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1148181%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F543326%22%20target%3D%22_blank%22%3E%40JakeRoper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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,

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

3 Replies
Highlighted
Best Response confirmed by JakeRoper (New Contributor)
Solution

@JakeRoper 

 

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

 

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

Highlighted

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

Highlighted