title: Excel shorting and writing blank column
body: <p>I want to find and write the blank value from first non blank column to the blank cell. for example:-</p>
  
  <pre><code>Column A
  ----------------
  -Blank cell- 
  -Blank cell-
  abc
  abd
  -Blank cell-
  -Blank cell-
  -Blank cell-
  xyz
  ycz
  </code></pre>
  
  <p>My Result should be </p>
  
  <pre><code> Column B
  -----------
  abc
  abc
  abc
  abd
  xyz
  xyz
  xyz
  xyz
  ycz
  </code></pre>
  
  <p>there are more than 25K entries with me and blank cells are not specified. Can someone please help me with this. any Excel formula or script will work</p>