title: Excel Macros: From Table to Column
body: <p>I have an Excel table with multiple rows and columns like this:</p>
  
  <pre><code>1 2 3
  4 5 6
  7 8 9
  </code></pre>
  
  <p>I need to write macros, which will transform all my data in one single column and will place it in <code>sheet2</code></p>
  
  <pre><code>1
  2
  3
  4
  5
  6
  7
  8
  9
  </code></pre>