The MERGEJSON function allows you to parse the data from multiple rows of a JSON column. The JSON column would contain an array of objects.
- sheet: is the sheet that contains a JSON column
- jsonColumn: is the column that contains an array of objects.
which would return an array of JSON objects.
To further understand how to use the MERGEJSON function, refer to this article here.