title: Excel combining up to 100 ranges that have similar but not identical columns into one
body: <p>I'm pulling in data for unique items and each item has a potentially unique set of columns that go with it. So for instance as a trivial example two ranges might look this: </p>
  
  <p>Range 1: </p>
  
  <pre><code>Brand   Year  MPG   Sales
  Nissan  2000  25    150
  Nissan  2005  27    180
  Nissan  2008  30    190
  </code></pre>
  
  <p>Range2: </p>
  
  <pre><code>Brand   Year    Sales
  Honda   2000    95
  Honda   2001    100
  Honda   2001    150
  </code></pre>
  
  <p>Ideally I would like to combine into one named range:</p>
  
  <pre><code>Brand   Year    MPG Sales
  Nissan  2000    25  150
  Nissan  2005    27  180
  Nissan  2008    30  190
  Honda   2000    Null    95
  Honda   2001    Null    100
  Honda   2001    Null    150
  </code></pre>
  
  <p>In reality I have something like 100+ named ranges like this and the columns vary from anywhere between 25-35. </p>
  
  <p>Is there a smart way to achieve the desired result? I'm trying right now to use vba to loop through each range and check if the row exists, but that seems like kind of a sloppy solution and I'm having issues getting it to work, but I can probably brute force it through. </p>