Sheet formula to repeat the cells

Question

I have a table where it needs to be repeated whenever there is a value 1 in A column D2 number of times as shown

I have tried with =QUERY(A1:D7,"select C,B where A=1")

Prefer to have a single long formula that can accomplish.

Your question can be greatly improved if you add input table and expected output table to the question. [Tables](https://webapps.stackexchange.com/a/161855/) are a better alternative than spreadsheets to show your data structure. If you share spreadsheets, make sure to also add images of your sheet to avoid closure of your question, as questions here must be [self](https://meta.stackoverflow.com/a/260455) [contained](https://meta.stackexchange.com/a/149892). [Your email address can also be accessed by the public](https://meta.stackoverflow.com/questions/394304/), when you share Google files. — TheMaster, Sep 29 '22 at 17:54
Does this answer your question? [Repeat whole row N times based on column value in Google Sheets](https://stackoverflow.com/questions/73880042/repeat-whole-row-n-times-based-on-column-value-in-google-sheets) — TheMaster, Sep 29 '22 at 18:03
Does this answer your question? https://stackoverflow.com/questions/70160891/how-to-repeat-a-data-set-several-columns-x-times-in-google-sheets — TheMaster, Sep 29 '22 at 18:05

score 1 · Accepted Answer · answered Sep 29 '22 at 18:11

1

use:

=ARRAYFORMULA(SORT(SPLIT(FLATTEN(FILTER(C2:C6&"×"&
 SEQUENCE(1, D2)&"×"&B2:B6*SEQUENCE(1, D2), A2:A6=1)), "×"), 2, 1))

answered Sep 29 '22 at 18:11

player0

1 Answers1