Have trouble transposing XML Data

[GoranH]

Good day,

I've having trouble transposing a bunch of XML bracket data horizontally.

Data is like so

[TABLE="width: 500"]
<tbody>[TR]
[TD]App[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]/App[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]App[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]/App[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I need it to look like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]App[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]/App[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]App[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]/App[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I also should note that there are 700k lines, so solution I tried with index match and transpose doesn't work as my excel breaks after about 5 thousand items.
I'll see to attach a more representative example bellow as soon as I find a way to attach a file.

https://ibb.co/Q97BM7k

Here's the link to the image, if that helps.

 

[Worf]

You can upload a XML or XLS file to a site like Drop Box and paste a link here.