HTML to *.xlsx conversion of large table.

A trading statement has 10,500 entries (6.5mb) covering a two year period all in html. Each entry is spread over two lines, see preview below, and the wraparound properly belongs to the preceding line, it is part of the same entry. In order to analyse the performance of the various files (eg Adele, Oscar, Brian, Uniform etc) it is necessary to convert the html table to a *.xlsx file that can be manipulated using Excel and have every entry on a single line A two entry, four line, sample of the table is shown below: Ticket O pen Time Type Size Item Price S / L T / P C lose Time Price C ommission Taxes Swap Profit Comment 25840322 2013.09.23 15:00 sell 0.11 audnzd 1.12603 0.00000 0.00000 2013.09.23 21:03 1.12672 0.00 0.00 0.00 -6.74 657454 Uniform v3 B3 v3.96 audnzd M1 25840387 2013.09.23 16:51 sell 0.22 audnzd 1.12719 0.00000 0.00000 2013.09.23 21:03 1.12672 0.00 0.00 0.00 9.18 657454 Uniform v3 B3 v3.96 audnzd M1 Once the entire table has been converted and the cancelled entries deleted all entries using the same set file (eg Adele, Oscar, Brian, Uniform etc) should be posted to a separate worksheet to make analysis more straightforward.