I have an XML with 105,000 lines. I found out how to import this into
Excel from a message on the board and a link to
http://www.cpearson.com/excel/ImportBigFiles.aspx.

Now I have two worksheets with the data.

Currently I have this basic structure throughout the worksheets:

<1
<2
<3
<4
Etc

Each node is in its own column.

I want to change my worksheets so every node in listed in every
column. Like this:

<1
<!<2
<1<2<3
<1<2<3<4

I don't want to Ctrl+D the needed nodes through 105,000 lines.

Any suggestions?

Thanks,

Nick