C
C
Crowcloud2020-02-19 05:38:06
Google Sheets
Crowcloud, 2020-02-19 05:38:06

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
5e4c9e09f3d0d101703788.jpeg
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:
5e4c9e7ba5d7e126664623.jpeg
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

1 answer(s)
A
Alexander Ivanov, 2020-02-19
@oshliaer

The formula SLIPTseems rational
=IFERROR(SPLIT(REPT(B2&"|";A2);"|");"")
5e4cd57fbd121766332362.png
In addition, supports ARRAYFORMULA

=ARRAYFORMULA(IFERROR(SPLIT(REPT(B2:B&"|";A2:A);"|");""))

Table with example .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question