Answer the question
In order to leave comments, you need to log in
How to copy a Google Sheets cell n times to adjacent row cells when n=cell value?
There is an array of the type: It is
necessary to fill with the value of the second cell of the row n neighboring cells on the left, where n = the value of the first cell of the row.
Desired result example:
Is it possible to solve this problem without plugins, using GSheets built-in tools alone?
Answer the question
In order to leave comments, you need to log in
The formula SLIPT
seems rational
=IFERROR(SPLIT(REPT(B2&"|";A2);"|");"")
In addition, supports ARRAYFORMULA
=ARRAYFORMULA(IFERROR(SPLIT(REPT(B2:B&"|";A2:A);"|");""))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question