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.