Splitting Cells

[silvrwoman]

Is there a way to split multiple cells, not whole columns, at once even when there's rows in between I don't want split? Please see my example photo attached - I want to make the company names (i.e. "Company A, Inc") a separate cell from the project names (i.e. "Project ABC"), but leave all the other cells alone. I have hundreds of these in the spreadsheet and don't want to have to do it manually.

Thanks!

Edit: Sorry - here's an excel version:
Example 2.xlsx

P.S. Please ignore the JPEG, I can't figure out how to remove it.