help me split into two rows

[lochness8]

I have hundreds of rows like these. I would like to break up this row into two rows.
I have (soft return inside cell)

CHEM-120

MW W

11:10AM 7:50AM

12:35PM 11:00AM

W222 E237

Diane, Joe

01/28/2019

05/24/2019

<tbody>
</tbody>

I would like it to be on separate rows:

CHEM-108-9107

MW

11:10AM

12:35PM

W222

Diane

01/28/2019

05/24/2019

<tbody>
</tbody>

CHEM-108-9107

W

07:50AM

11:00AM

E237

Joe

01/28/2019

05/24/2019

<tbody>
</tbody>

Any suggestions on how to do this in excel? will i need VBA?

Thanks!

****** id="cke_pastebin" style="position: absolute; top: 185.6px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">05/24/2019

</body>

 

[wist]

copy the column where you have more lines in one cell -> paste to notepad (I assume the cell with will be pasted in quotation marks) ->replace quotation marks for nothing-> copy data from notepad -> paste to word -> replace spaces for line breaks "^p" -> copy data from word -> paste back to excel

should work if you have spaces between the lines ..if you have them between other words you dont want to replace its a bigger issues ..if you dont have spaces at all there you will have to find some other character that you could replace i.e. if you have something like "12:35PM11:00AM" you could replace M for M^p