Control over unnecessary rows

[akonyar]

Hello all!

I imported all my data from an ecommerce API that gives me the orders. Some of the arrays have multiple objects in them. So the ImportJSON function makes them in a new row, which is makes unnecessary rows and hard to process data in sheets afterwards.

even so some of multiple rows are important to be in new rows, for example an order which contains multiple products.

my questions is:

1- How can I use google sheets function CONCATENATE (or something like this) to packageHistories/status header to be in a single cell, not to be in rows.

2- How can I organize rows which should follow the rows it belonging to (this should be 2 rows)

thank you