title: Cross Join in Excel
body: <p>I have two ranges in excel.  I'm looking for a simpler way to combine each row of Range1 with each row of Range2.   The number of columns and rows in each range can change.  Refer image below</p>
  <p>Can it be done only with Macro or is there way to do it in normal or dynamic array formulas.</p>
  <p>Or do you suggest a dynamic array UDF</p>
  <p><a href="https://i.stack.imgur.com/p7LM3.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p7LM3.jpg" alt="enter image description here" /></a></p>