How can we unpivot data

[treesa2010]

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 it as below data

u	v	t
Deg. C	14.1	29/11/2023 3:21

@PowerBI 

Thanks

[treesa2010]

@swikritee_p thanks it worked.

[swikritee_p · Accepted solution]

@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