Google sheets- entered values in B5:BL5 and i need it to repeat across row 5 all the way to og5. I need it to do it automatically. I have tried a scrip that doesn't work cause i don't know what I'm doing. I'm hoping there's a formula that can do this



1 Answer 1


You can repeat the values in B5:BL5 several times with something like this:

  d, B5:BL5, 
  array_constrain(hstack(d, d, d, d, d, d, d), 1, columns(BM5:OG5)))

Put the formula in cell BM5.

Note that the values will be view-only because formula results cannot be directly edited. To make them editable, select the values and press Control+C to copy and Control+Shift+V to paste values only.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.