I've got a large document that's not quite formatted properly for what I need and the amount of time it's going to take to cut/paste everything if I do it manually is going to be prohibitive.



Below are screen shots of how the current document looks and how it should look.

Best way to describe it is that there are various lines in the 'Planned Activity' 'Timeframe' and 'Status' columns but they are all listed in a single cell.

I would like to make each of those lines go into a new row so that they can be copy/pasted more easily into Excel at a later date.

I've tried splitting the cells but it just created the new cells underneath and left the list in the top cell. That means I'd still need to cut and paste each individual line

Current format
https://postimg.org/image/8x7xuw2ul/


Desired format
https://postimg.org/image/uweci4m9p/