title: How to split a single row into multiple columns in Excel
body: <p>In Excel, I want to split up the data in row 1 into four single columns. A1:D1 should remain in place. E1:H1 should become A2:D2 and so on.</p>
  
  <p>I am currently using this formula in A2:</p>
  
  <pre><code>INDEX($1:$1;(ROW()-1)*4+COLUMN()-1)
  </code></pre>
  
  <p>... But I am getting a <code>#REF!</code> error.</p>
  
  <p>How do I solve this problem?</p>