Splitting content in separate columns

Hello MarvinP,

Unfortunately, my data is much more messier than Jen2412 and I really hope you can help me. I have cells that contain different/multiple lines and I had to split it for report purpose.

Kindly see my attachment, cell-C9.. I would like to have "2nd Line of Column-A" to be blank if the original data consist of only 1 line.. Same result as in "3rd Line of Column-A" and "4th Line of Column-A".

Hope you understand what I'm trying to explain.

Rgds,
CSMiin