Split data from one cell into two new rows

[ports83]

Hi Guys,
I have a spreadsheet which includes a number of product codes in column B, some of which display two codes in one cell with the second code inside brackets. I need a macro that identifies when a cell contains brackets and then inserts two rows below, the first to be filled with the first product code not in brackets, and the second row to be filled with the second product code which is inside brackets. The empty cells to the left and right of these new cells need to be populated with the data from the original row.
I have attached a spreadsheet with two tabs, one for before and one after to show you what I mean as I'm sure I’ve just confused you…