title: Excel: need to transpose one field of multiple values while duplicating the remaining fields
body: <p>I have a spreadsheet that has column E that requires values split (comma separated values currently) and transposed to multiple rows. Columns C, D, F-S need copied down. Example:
  Columns</p>
  
  <pre><code>+-----+-------+------------------+-------+--------+--------+----------+
  |  C  |   D   |        E         |   F   |   G    |   H    | ... S    |
  +-----+-------+------------------+-------+--------+--------+----------+
  | 20  |  hey  |  one, two, three |  xyz  |  unit  |  right | ... end  |
  +-----+-------+------------------+-------+--------+--------+----------+
  </code></pre>
  
  <p>I need it to look like:</p>
  
  <pre><code>+-----+-------+--------+-------+--------+--------+---------+
  | C   |   D   |   E    |   F   |    G   |    H   |  ... S  |
  +-----+-------+--------+-------+--------+--------+---------+
  | 20  |  hey  |  one   |  xyz  |  unit  |  right | ... end |
  | 20  |  hey  |  two   |  xyz  |  unit  |  right | ... end |
  | 20  |  hey  |  three |  xyz  |  unit  |  right | ... end |
  +-----+-------+--------+-------+--------+--------+---------+
  </code></pre>
  
  <p>any help would be great!</p>