Not Getting XML Data In Power Query Properly

[Anonymous]

Hi All,

When i am importing data from from web and that has value in XML, the headers are showing in a column and not as headers. The value are repeatitive because it is for ever device so can not use Pivot. Just next to that column there is column which has information for these headers. Please if anyone can help. I am stuck on this for 3 days now.

[Fowmy]

@Anonymous 

If you can share a sample XML file and the expected results in an Excel sheet, then it would it much easier to solve.

[Anonymous]

@Fowmy 

Thanks for quick response. I am getting data from a link which has data in XML (Attached). Also attached how it it visible in Power Query and how i want. Appriciate your help.

It has data for many devices so these Attribute.ID are repeating.

[Anonymous]

Hi @Anonymous ,

Try to use the Transpose function to turn your rows into columns and your columns into rows.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.