Forum Discussion
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 it as below data
| u | v | t |
| Deg. C | 14.1 | 29/11/2023 3:21 |
Thanks
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
2 Replies
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 Delimitersswikritee_p thanks it worked.
