title: Convert Multiple Rows into Single Stacked Column in Excel
body: <p>I have this huge data of Market Share of various brands which looks like this:</p>
  
  <pre><code>1111 2222 3333 4444
  5555      7777 8888
  9999 0001 0002
  0004 0005 0006 0007
  </code></pre>
  
  <p>What macro code can be used to get output of:</p>
  
  <pre><code>1111
  2222
  3333
  4444
  5555
  &lt;emptyCell&gt;
  7777
  8888
  9999
  0001
  0002
  &lt;emptyCell&gt;
  0004
  0005
  0006
  0007
  </code></pre>
  
  <p>The Empty cells must also be considered.</p>
  
  <p>Also is there a possibility for getting the output in other Sheet ?</p>