Split one line into two and automate up until end of table

[peter_nemeth]

Hi all

I have got list of suppliers as below:

[TABLE="width: 500"] <tbody>[TR] [TD]WIL001	WILSON	01/05/18	I	1232	124.51	24.9	149.31
EPE001	EPE INTERN	01/05/18	I	PSNIV176908	157.8	31.56	189.36
DEX001	DEXAM	01/05/18	I	X00013571	233.02	46.62	279.64

<tbody>
[TD="class: xl65, align: right"][/TD]
[TD="width: 64"][/TD]
[TD="width: 90"][/TD]
[TD="width: 64, align: right"][/TD]
[TD="width: 64, align: right"][/TD]
[TD="width: 64, align: right"][/TD]

</tbody>

[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]I would like to transform it into this format. How can I create two lines as header and line from one invoice/row and then go down and do the same with second invoice all the way down??
[/TD]
[TD][/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"]

H|01|1|INV|WIL001|1232||05//2018|124.31|24.9|149.31|GBP|A
[/TD]
[/TR]
[TR]
[TD="class: xl65"]L|01|1232|1|10|5000||124.51|24.9|149.31|20.00||A

<tbody>
</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Many thanks![/TD]
[TD][/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

<tbody> [TD="class: xl65"]

<tbody>

[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]

</tbody>

[/TD]

</tbody>

<tbody>
</tbody>