Forum Discussion

treesa2010's avatar
treesa2010
Frequent Visitor
2 years ago
Solved

How can we unpivot data

Hi All, I can use delimiter and spilt the below data. But I just wanted to know is there an easy way to unpivot the below data?   {"u": "Deg. C", "v": 14.1, "t": "2023-11-29 03:21:52"}   i wanted...
Need Help
Show and Tell
  • swikritee_p's avatar
    swikritee_p
    2 years ago

    treesa2010 , In Power Query( Home Tab-> Transform Data -> Transform Data )

     

    You should be able, right click on Column, and force it as JSON , after that use Exapd icon and expand 

     

    expand





    You have option for split by Delimiters