Insert new row for breakdown detail data

Good Day Mates,

I'd like to seek your help for my problem.

I have Raw Data in row 2 - 6 and my expectation is to breakdown each raw data by REMARKS INVOICE PAYMENT as can be seen in row 9 - 17.

RAW.JPG

Expected.JPG

If Remarks Invoice Payment contain more than one invoice than it need to be insert as new row, and also including the amount of invoice which contain in between the brackets "( )".

Highly appreciated for the feedback. Thank you!

Cheers!