Redistributing OR Split Column Info Into Separate Rows

[schorr]

schorr, can you upload a sample workbook, along with the expected result

Okay I uploaded a file with the run-on row and another file with the desired result. Basically everything after the % I would like to drop to a new line. Preferably starting under the Paid Date field. All the field separated by the % need to repeat under the Paid Date, Invoice Date, Invoice Number, etc... Does this make sense? These are order records so under each title there are multiple payments.

Thanks in advance for your help.