title: Merge values in multiple columns into one
body: <p>I have the following data structure:<br><br>
  <img src="https://i.stack.imgur.com/xUq7X.png" alt="Data+Expected Results+What I get">
  <br><br>
  As you see in <strong>column J</strong>, I am trying to merge data into one column from columns <strong>A</strong> &amp; <strong>C</strong> &amp; <strong>E</strong> &amp; <strong>G</strong>. </p>
  
  <p>I am using this formula:<br></p>
  
  <pre><code>=IF(ROW()&lt;=COUNTA($A:$A);INDEX($A:$C;ROW();COLUMN(A1));INDEX($A:$C;ROW()-COUNTA($A:$A)+1;COLUMN(C1)))
  </code></pre>
  
  <p>and I get the values in column <strong>K</strong> as you see. Currently this formula is merging only two columns. <strong>How to modify it to merge all four columns?</strong></p>
  
  <p><br>
  And how to only get those values starting from <strong>row 5</strong>?
  <br>The column height will vary constantly: sometimes there are 10 values in column A and sometimes there are 2 values.</p>
  
  <p><br><em>Either any excel formula or any VBA code will be acceptable.</em></p>