title: Create a list of combinations of all values from one column with all values from another in Google Sheets
body: <p>Is there any formulaic way of recursively working through one column and combining it with values from another? For illustration, given...</p>
  
  <p>Column A:</p>
  
  <pre><code>A
  B
  C
  </code></pre>
  
  <p>and </p>
  
  <p>Column B:</p>
  
  <pre><code>1 
  2 
  3
  </code></pre>
  
  <p>can I generate...</p>
  
  <p>Column C:</p>
  
  <pre><code>A1
  A2
  A3
  B1
  B2
  B3
  C1
  C2
  C3
  </code></pre>