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