Format One Column HTML Table as Multiple Column Table

[adelmonte]

Hi all,

I am trying to format a dynamic HTML Table that I copy from a website to Excel.

When I copy the table to Excel it is copied in a single Excel Column.

I need to have proper headers and values, as I am showing you in the attached Excel file and screenshots.

Anyone able to provide me help or give me a hint on how to do it in an automated way instead of copying and transposing every single row?

Copied HTML Table

Desired Outcome

Excel File

Thanks in advance.

Alex

[adelmonte · Accepted solution]

I solved the problem using Power Automate Desktop

3 steps flow:

Open Browser

Click on search button 

Extract table in Excel

[amitchandak]

@adelmonte , have you tried web url as source directly in power bi ?