Spliting Cells Into Multiple Rows

I am looking for someone that might be able to help me with an unusual request. Here is the scenario:

I have an Excel table that pulls data straight from an Access DB. That Access DB pulls straight from a SharePoint list. When it is imported into Access, the records looks like this:

First NameLast NameIssueRemediationJohnSmithIssue 1
Issue 2
Issue 3Remediation 1
Remediation 2
Remediation 3

When it is imported into Excel, it keeps the formatting above (Multiple issues and remediation’s in 1 cell). I want to split those multiple inputs into multiple rows, without deleting the row below it. I would like it to look like this:

First NameLast NameIssueRemediationJohnSmithIssue 1Remediation 1 Issue 2Remediation 2 Issue 3Remediation 3

Or

First NameLast NameIssueRemediationJohnSmithIssue 1Remediation 1JohnSmithIssue 2Remediation 2JohnSmithIssue 3Remediation 3

how I can do this without manually going into the file and editing it myself every time?