Split Text Across Multiple Columns and Add Additional Text

Revised workbook per request. Columns E and G:O are the ones in question. I've updated the information as accurately as possible. Hopefully this gives you a better idea of what I'm talking about and also the challenges ahead. Thanks again for all the help.