How to Separate Text and Add New Rows Automatically

Hey Everyone,

Great site here. I have a spreadsheet with text separated with semicolons that I would like to separate into rows and automatically insert below the current row. Then proceed to the next row and process that one the same way. The hard part is that there is data in the column before and after that should remain the same for each new row created. Please see the spreadsheet and hopefully it makes more sense.

I can do it manually by doing Text to Columns, manually adding the correct amount of rows, transposing, then copying the column before and after down. I'm hoping for an automatic way. I'm a noob so please talk slowly Thanks.