2

I want to do something like this : enter image description here

The value can be a character or some words.

If the value is number (for example = 0) then i can do :

sequence(11,6,0,0)

But i can't use character or words.

Thanks

3

Try this formula:

=ARRAYFORMULA(SUBSTITUTE(SEQUENCE(11,6,0,0), "0", "A"))

This uses SEQUENCE but substitutes the "0" values for the required text value.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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