Import and transform .json data Excel

Hello everyone!

EDIT: Found a solution using power query. https://excelunlocked.com/convert-json-to-excel

First post in Excel forum and I could really use some help. 

I would imagine there is an easy solution to this, but I keep getting suboptimal results. I have a few medium sized dataset from .json which is formatted like this:

I would like all of the values to be under its respective column, as such: 

I only manage to get something like this. 

or this: 

But due to combination with other data sources down the road this wont work. 

Best regards,

Theodor