Web Query cannot find table / data

[ggirf14]

Trying to get data from morningstar.com LINK.
Table view is showing only elements where data is not available.
The Web view show the page correctly but there is nothing I can select.

From the web page I copied to paste to Excel and notepad and all the data end up as a single column.
Same issue if I save the web page as pdf than copy from the pdf, the paste output = all data in a single column.
Transpose is not really an option as I would need to manually select each of the 1600 sections to transpose.

Thanks for helping.

 

[ggirf14]

I see with Notepad++ there is a CR/LF after everything = it gets pasted as a single column.

I guess the question would now be how to remove those CR/LF for every lines by blocks of 8 (the 9th line only have the CR/LF that I would need as seperator for each rows).

I would guess VBA would be a solution but my knowledge is very limited with this option.