title: Unmerging excel rows, and duplicate data
body: <p>I have been given a fairly large database stored in Microsoft Excel, which I have to try convert into something useful.<br>
  However, one of the problems that I am encountering is that some of the data is merged together (horizontally in 2s).</p>
  
  <p>For example;</p>
  
  <pre><code>row 1: [ x ][ x ][ x ][ x ][ x ]
  row 2: [ x ][ x ][ o    o ][ x ]
  row 3: [ o    o ][ x ][ o    o ]
  </code></pre>
  
  <p>Where x's are single cells and o's are merged together</p>
  
  <p>What I want to do is unmerge all the rows (which I could do fairly easy with the unmerge button), but for where the merged cell was, have the data duplicated across the 2 cells.<br>
  From; <code>[[ Some Data ]]</code><br>
  To; <code>[ Some Data ][ Some Data ]</code></p>
  
  <p>Thanks! Any help is appreciated.</p>