How to transform HTML table to new column

[Jared5566]

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!

[Jared5566 · Accepted solution]

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"])))

[wdx223_Daniel]