title: Generate range of numbers between two numbers
body: <p>I could use some help with a query to expand a CSV I'm working with, but I don't know the best way to handle the query.  My data looks like this:</p>
  
  <pre><code>ID-Begin | ID-End | Color | Dwelling
  -------------------------------------
  79000    | 79999  | Red   | Condo
  82100    | 82600  | Blue  | House
  etc
  </code></pre>
  
  <p>I need to generate a range between the beginning ID and ending ID, and then duplicate the color and dwelling entries for that range.  This is what I'm hoping to achieve:</p>
  
  <pre><code> ID   |  Color  | Dwelling
  ------------------------
  79000 |  Red    | Condo
  79001 |  Red    | Condo
  79002 |  Red    | Condo
  .....
  79999 |  Red    | Condo
  82100 |  Blue   | House
  82101 |  Blue   | House
  .....
  82600 |  Blue   | House
  </code></pre>
  
  <p>I've see other methods that allow me to generate a single range of numbers, but nothing that pulls the beginning and ending numbers from the columns in a table.</p>
  
  <p>Anyway help is greatly appreciated!!</p>
  
  <p>Storm</p>