Good day,
I've having trouble transposing a bunch of XML bracket data horizontally.
Data is like so
<tbody>
</tbody>
I need it to look like this
<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.
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.
Last edited: