Forum Discussion

Jared5566's avatar
Jared5566
New Member
3 years ago
Solved

How to transform HTML table to new column

Hi All,

 

I have a problem with Power Query. One of my columns is HTML table data like:

<table>

<tbody>

<tr><td valign="top">Contact_name</td><td>Jack</td></tr>

<tr><td valign="top">Gender</td><td>Male</td></tr>

<tr><td valign="top">Age</td><td>18</td></tr>

...

</tbody>
</table>

 

 

The HTML table contains the the column name and value:

Contact_name

Jack

Gender

Male

Age

18

 

I want to convert the html table to new column like:

 

Any help that could be provided on my requirement would be greatly appreciated.😂

Thanks!

Need Help
Tips and Tricks
Tutorial Requests
  • Jared5566's avatar
    Jared5566
    3 years ago

    Hi wdx223_Daniel ,

     

    Thanks for your answer.

     

    I finally find out the soultion:

    Table.PromoteHeaders(Table.Transpose(Html.Table(Source, {{"Column1", "TABLE > * > TR > :nth-child(1)"}, {"Column2", "TABLE > * > TR > :nth-child(2)"}}, [RowSelector="TABLE > * > TR"])))

2 Replies

  • Jared5566's avatar
    Jared5566
    New Member
    3 years ago

    Hi wdx223_Daniel ,

     

    Thanks for your answer.

     

    I finally find out the soultion:

    Table.PromoteHeaders(Table.Transpose(Html.Table(Source, {{"Column1", "TABLE > * > TR > :nth-child(1)"}, {"Column2", "TABLE > * > TR > :nth-child(2)"}}, [RowSelector="TABLE > * > TR"])))