Can't extract hyperlink from webtable using PowerQuery

[Anonymous]

Hi,

I have issue with extract hyperlink using PowerQuery in excel 2013, why PowerQuery see "blank cells"?

If I use traditional Web Query in Excel and i check option in Navigator "Full Html Formating" its work, but in power query its not work.

Anyone have solution for my problem ?
I erased data from other columns, because its not needed

[v-yulgu-msft]

Hi @Anonymous,

As this question is more related to Office, Excel, please post a new thread on proper forum so that you can more professional advice.

Regards,

Yuliana Gu