convert json data into a table

Question

Hi,I imported a json file and a table appeared with rowcount=394, columns=List, and data=Record ("Initial screen" image below).The "Columns" screen capture shows the result for when I clicked on "List".The "Data" screen capture shows the result for when I clicked "Record".How do I convert this data into a table?&nbsp;Initial screenColumnsData

phil_seamark · Answer

Hi&nbsp;cubedweller&nbsp;Right-click a few places in the Power Query data viewer (column header/record cell) and you may see the "Into Table" option in the menu that pops up.&nbsp; Or check for a "Convert" table in your ribbon&nbsp;