Help with Json transformation

[Markzolotoy]

My table looks like this:

Where Record is Json data. When I click with the right mouse on the column I dont get Transform option. Is that right?

Thanks

[Markzolotoy]

Results of my query are not showing in the Power Query.

[vpatel55 · Accepted solution]

This needs to be done in Power Query. Click on 'Transform Data' in the 'Home Group:

Then click on the expand arrows. You may need to undo some steps in Power Query to get to see this:

Hope that helps.