title: Repeat each row N times in Google Sheets
body: <p>I have a column containing 3 rows and I want to be able to repeat those rows 5 times each.</p>
  <p><strong>Example</strong></p>
  <pre><code>| Name |
  |------|
  | Dog  |
  | Cat  |
  | Ball |
  |------|
  </code></pre>
  <p><strong>Desired Output</strong></p>
  <pre><code>| Output |
  |--------|
  | Dog    |
  | Dog    |
  | Dog    |
  | Dog    |
  | Dog    |
  | Cat    |
  | Cat    |
  | Cat    |
  | Cat    |
  | Cat    |
  | Ball   |
  | Ball   |
  | Ball   |
  | Ball   |
  | Ball   |
  |--------|
  </code></pre>
  <p>Here's what I have tried:</p>
  <pre><code>=TRANSPOSE(split(rept(join(&quot;;&quot;,A:A)&amp;&quot;;&quot;,5),&quot;;&quot;))
  </code></pre>
  <p><strong>My attempt produces:</strong></p>
  <pre><code>| Output |
  |--------|
  | Dog    |
  | Cat    |
  | Ball   |
  | Dog    |
  | Cat    |
  | Ball   |
  | Dog    |
  | Cat    |
  | Ball   |
  | Dog    |
  | Cat    |
  | Ball   |
  | Dog    |
  | Cat    |
  | Ball   |
  |--------|
  </code></pre>