I'd like to automatically populate a dynamic list where values are repeated on each row separately. The number of repetitions is in column A and the value to repeat is in column B. The formula should go into column C, like this:

table expected behaviour

1 Answer 1


You can repeat values with the sequence() function like this:

=sequence(1, A2, B2, 0)

...where A2 contains the number of repetitions and B2 contains the value to repeat.

See sequence().


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.