title: How do I convert a single vertical row into multiple row array in Excel?
body: <p>I am currently trying to convert a single vertical row in Excel into an array in multiple rows of 5.  So, for example I have</p>
  
  <pre><code>A1 1000
  A2 1001
  A3 1002
  A4 1003
  A5 1004
  A6 1005
  A7 1006
  ...
  </code></pre>
  
  <p>And I'm trying to convert it to a multiple row array like below:</p>
  
  <pre><code>1000 1001 1002 1003 1004
  1005 1006 ...
  </code></pre>
  
  <p>I had previously done this in Excel but I cannot remember how I did it.  I used the TRANSPOSE function but I cannot remember the logic on how to shift the reference by 5 on the next row.  Does someone know a function I could use?</p>