title: Google Sheets Split Column into multiple columns
body: <p>There's this formula that seems to work in this <a href="https://stackoverflow.com/questions/63531300/splitting-single-column-into-multiple-columns-1000-rows-per-column">example</a>:</p>
  <pre><code>=ARRAYFORMULA(VLOOKUP(TRANSPOSE(SEQUENCE(ROUNDUP(COUNTA(A2:A)/3),3,ROW(A2))),{ROW(A2:A),A2:A},2,0))
  </code></pre>
  <p>but when I try to use it for a range of 26 cells in a single column(K3:K28) to split it every 6 cells, using this formula:</p>
  <pre><code>=ARRAYFORMULA(VLOOKUP(TRANSPOSE(SEQUENCE(ROUNDUP(COUNTA(K3:K28)/6);6;ROW(K3)));{ROW(K3:K28);K3:K28};2;0))
  </code></pre>
  <p>it gives the error: VLOOKUP evaluates to an out-of-bounds range.</p>
  <p>How to fix it??</p>