How to make a range repeat n-times in Google SpreadSheet
<p>I use <code>ArrayFormula()</code> to simplify the way I create my reports. </p>

<p>Instead of having to create a reference in each cell (eg. <code>=C1</code>,<code>=C2</code>,<code>=C3</code>,<code>=C4</code> in each cell, I just use <code>=arrayformula(C1:C4)</code> in one single cell. It does exactly same job, but is much simpler and it keeps things more organized, because I just need to look in one cell for possible errors.</p>

<p>It works great when I have to reference a range into another like take the values of C1:C4 into the A1:A4 range. In the A1 cell I would just write <code>=arrayformula(C1:C4)</code> and it does its magic.</p>

<p>It does get a bit trickier when the ranges are not the same length, but it is feasible nonetheless. For instance, if I want to stack two or more range link C1:C4 on top of B1:B3, on cell A1 I can write <code>=arrayformula({C1:C4;B1:B3})</code>.</p>

<p>My problem is using <code>arrayFormula()</code> to copy a repeating pattern. For instance, if I want to copy the content of cell C1 4 times I would use <code>=arrayformula({C1;C1;C1;C1})</code>.</p>

<p>This would work and would achieve the desired effect. However, I was wondering if there is a better way to do that. Something like <code>=arrayformula({C1}*12)</code> were this pattern would repeat 12 times. This would also enable me to have a dynamic formula, such as <code>=arrayformula({C1}*count(D:D))</code> where the pattern would repeat according to some variable.</p>

<p>Do you have any ideia on how to achieve that using only native formula (no javascript)?</p>