title: Excel Copy and Paste Merged Cells into Single-Cell Format
body: <p>I'm trying to copy over some data from a set of merged cells into a single cell format. I don't know how to do this.</p>
  
  <p>I'm trying to copy this:</p>
  
  <p><img src="https://i.stack.imgur.com/Revbs.png" alt="enter image description here"></p>
  
  <p>This is what I get when I paste it:</p>
  
  <p><img src="https://i.stack.imgur.com/sq7dy.png" alt="enter image description here"></p>
  
  <p>This is what I want to happen when I paste it:</p>
  
  <p><img src="https://i.stack.imgur.com/NfKJ6.png" alt="enter image description here"></p>
  
  <p>Since my merged cells "are" single cells, I wish they would paste like single cells. I haven't found a solution anywhere. I know that you can Special Paste values, but that doesn't keep the formatting that I need. </p>