title: Pulling data from one spreadsheet and inserting it into a template?
body: <p>I'm looking for a way to take a spreadsheet full of data and move it into another spreadsheet that's set up as a faux rack diagram.</p>
  
  <p>For example, I would like to take data formatted as:</p>
  
  <pre><code>+------+---+-------------+-------+---------+-------+
  | Rack | U | Service Tag | Model | Project | Owner |
  +------+---+-------------+-------+---------+-------+
  </code></pre>
  
  <p>And insert into a new spreadsheet where "Rack" is a preexisting column header, "U" is a value in the first column, and the other four cells are merged together into one cell. So:  </p>
  
  <pre><code>+-----+----+---------+--------+---------+----------+
  | 566 | 36 | 1234567 | Server | Project | John Doe |
  +-----+----+---------+--------+---------+----------+
  </code></pre>
  
  <p>would be converted to:</p>
  
  <pre><code>+-----+-----+-----+-----+-----+----------+-----+-----+-----+
  |  U  | 001 | 002 | ... | 555 |    566   | 567 | ... |  n  |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 042 |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 041 |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | ... |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 037 |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 036 |     |     |     |     | John Doe |     |     |     |
  |     |     |     |     |     | Server   |     |     |     |
  |     |     |     |     |     | Project  |     |     |     |
  |     |     |     |     |     | 1234567  |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 035 |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | ... |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 002 |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  | 001 |     |     |     |     |          |     |     |     |
  +-----+-----+-----+-----+-----+----------+-----+-----+-----+
  </code></pre>
  
  <p>where the first row and column are already defined.</p>
  
  <p>Is there any way to automate this, or am I just stuck doing it manually?  </p>
  
  <p>I would have no problem doing it manually if there weren't over 900 entries that needed to be ported over.</p>