IMPORTJSON accepts a range of data sources like A1:A10 in which each cell should contain a URL, cURL or Google drive file ID.
Let’s say that you want to compare two Instagram profiles:
we have added some URLs in B1:C1 and some filters in B3
IMPORTJSON will output data from each profile side-by-side (column B and column C)
If IMPORTJSON detects that the data of all the data sources is based on an array, the function will try to pivot the data.
It makes sense if all the JSONs are, for instance, arrays of users. The expected results is that each user has their own column.
You can still force IMPORTJSON to display the results side-by-side by using the compare option:
=IMPORTJSON(a_list_of_urls, some_options, "compare")