Forum Discussion
Not Getting XML Data In Power Query Properly
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 no...
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.
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.
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.