Home > Software design >  Importing multiple 1D JSON arrays in Excel
Importing multiple 1D JSON arrays in Excel

Time:11-27

I'm trying to import a JSON file containing multiple unrelated 1D arrays with variable amount of elements into Excel. The JSON code i made is : `

{
    "table":[1,2,3],
    "table2":["A","B","C"],
    "table3":["a","b","c"]
    }

` When I import the file using power querry and expand the columns it multiplies the previous entries each time I expand a new column.

enter image description here

  • Related