title: How to combine 2 seperate arrays to an extensive combined list in excel
body: <p>I've been looking for it everywhere but I can't seem to find the answer although it seems an regular problem.</p>
  
  <p>I'm trying to automate the duplication of cells in excel. 
  I have two lists: list 1 with values 1,2,3,4 and the second list is with values a,b,c,d.
  Now I want to have a file where for every value in list 1, the values in list two are duplicated in excel. So:</p>
  
  <pre><code>1 - a
  1 - b
  1 - c
  1 - d
  2 - a
  2 - b
  2 - c
  2 - d
  3 - a
  ...
  </code></pre>
  
  <p>I'm wondering if there's a function within excel or if not a macro that I could use to solve this? For this short list it is of course easy to do with autofill, but when the list consists of a few hundred values, it gets more complicated...</p>