title: Excel fill down but on my terms
body: <p>I'm basically looking to recreate 1 column of hostnames in Excel on another column but with 2 spaces between each hostname.</p>
  
  <p>e.g.  column A</p>
  
  <pre><code>A1:  hostname1
  A2:  hostname2
  </code></pre>
  
  <p>I need a formula to have column c have all the data from column a but automatically put 2 blank cells between as below.</p>
  
  <p>e.g.  column c</p>
  
  <pre><code>A1:  hostname1
  A2: 
  A3:
  A4:  hostname2
  A5:
  A6:
  A7:  hostname3
  </code></pre>
  
  <p>I've tried macros and other methods but can't get excel to see the pattern in the spacing.</p>