title: Create combinations in Excel VBA
body: <p>I've scoured the entire website trying to look for a macro (or function) that will create unique combinations from a given list in adjacent columns.</p>
  
  <p>So basically, I have:</p>
  
  <pre><code>A  1  F1  R1  
  B  2  F2  
  C     F3  
  D  
  E  
  </code></pre>
  
  <p>And I'm trying to list all the information as (in the same worksheet and in different columns):</p>
  
  <pre><code>A 1 F1 R1  
  A 1 F2 R1  
  A 1 F3 R1  
  A 2 F1 R1  
  A 2 F2 R1  
  A 2 F3 R1  
  B 1 F1 R1  
  B 1 F2 R1  
  B 1 F3 R1  
  B 2 F1 R1  
  B 2 F2 R1  
  B 2 F3 R1  
  ...etc.
  </code></pre>
  
  <p>(added bonus for being able to toggle where the list is printed on the sheet)</p>