Parsing Excel Column based on Line Feed/Carriage Return?

I have an excel worksheet that contains muliple entries in 1 column. The entries represent diagram names. I would like the ability to split the names, but am unsure what to use for the separator. It would be very cool, if I could actually split the columns and create new rows based on the information.

For example in the first row of the attached spreadsheet there are 2 columns Name and Diagram.

So for the first row we have name: App1
diagrams: Service Design
Service Ordering
Work Management
It would be great if I could either split the diagram column into 2 columns based on the line feed/carriage return or better yet, create 2 rows each containing:

app 1 Service Design
app 1 Service Ordering
app 1 Work Management
app 2 Service Implementation
app 2 Work Management
app 2 Work Center Architecture Platform