Have trouble transposing XML Data

[GoranH]

Good day,

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

Data is like so

App
	a
	b
	c
	d
/App
App
	a
	c
	d
	e
	f
/App

<tbody>
</tbody>

I need it to look like this

App

a

b

c

d

/App

App

a

c

d

e

f

/App

<tbody>
</tbody>

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.