title: Merge cells and content in Excel
body: <p>I have a table in OneNote 2013 with 200 rows and 8 columns. The data looks something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/Dbtpi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dbtpi.png" alt="enter image description here"></a></p>
  
  <p>I have been tasked with transfering it to Excel. However, a simple copy and paste yields:</p>
  
  <p><a href="https://i.stack.imgur.com/PE3eo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PE3eo.png" alt="enter image description here"></a></p>
  
  <p>Is there a way that I might be able to make it look more like the original, or something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/SuY5x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SuY5x.png" alt="enter image description here"></a></p>
  
  <p>I know the basics of VBA and I have a guess that I could use the fact that Column A is always shown as spanning even is the number of bullet points, etcetera changes.</p>