Hi All,
I am currently using code to split data from a single column (copied from pdf) to separate columns for easy reading. There are over 5000 entries within the spreadsheet and it is slow to complete the macro. Does anyone have any tips for speeding this up or using powerquery instead? I've attached an output example and the code.
Thank you in advance.

My Code:
HTML Code: 
What i want to happen:
Spreadsheet.PNG


Thank you!