0

I have a table in OneNote 2013 with 200 rows and 8 columns. The data looks something like this:

enter image description here

I have been tasked with transfering it to Excel. However, a simple copy and paste yields:

enter image description here

Is there a way that I might be able to make it look more like the original, or something like this:

enter image description here

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.

Community
  • 1
  • 1
Chris Hagmann
  • 1,086
  • 8
  • 14

0 Answers0