Break Concatenated Field into Rows

I have Excel Data like below:

Patient Patient; DOB collection date Specimen Part(s); CPT Code(s)
SMELTZER, MICHAEL TED 6-Oct-50 30-Sep-10 88173; 88305CB
ELLER, MARION JOYCE 12-Oct-32 30-Sep-10 88173; 88172; 88172; 88305CB



This is what I would like the report to look like:

Patient Patient; DOB collection date Specimen Part(s); CPT Code(s)
SMELTZER, MICHAEL TED 6-Oct-50 30-Sep-10 88173
SMELTZER, MICHAEL TED 6-Oct-50 30-Sep-10 88305CB
ELLER, MARION JOYCE 12-Oct-32 30-Sep-10 88173
ELLER, MARION JOYCE 12-Oct-32 30-Sep-10 88172
ELLER, MARION JOYCE 12-Oct-32 30-Sep-10 88172
ELLER, MARION JOYCE 12-Oct-32 30-Sep-10 88305CB


Basically instead of the Specimen Part CPT field being concatenated I need a New Row for each CPT Code.

Any ideas on how this can be done would be appreciated