title: Excel combination of letters and numbers
body: <p>I have an Excel challenge and would appreciate any support! HELP!</p>
  
  <p>I have two columns in Excel. The first one contains a sequence of letters and the second one contains 5 numbers (1,2,3,4 and 5). So it kind of looks like this:</p>
  
  <pre><code>A  1
  B  2
  C  3
  D  4
  E  5
  F  
  G
  H
  </code></pre>
  
  <p>...</p>
  
  <p>I want to be able to combine every letter in the first column with each of the numbers and output this into a single column. In addition, I need a blank row in between the series. In other words, I need this:</p>
  
  <pre><code>A1
  A2
  A3
  A4
  A5
  
  B1
  B2
  B3
  B4
  B5
  </code></pre>
  
  <p>and so on.. I've been thinking about this for the better part of today but still can't think of anything..</p>
  
  <p>Thanks in advance!!</p>
  
  <p>Kind regards,
  Antonio</p>