Need help JQuery Datatables using JSON

bsksanjay

I am using Datatables Show / Hide child rows plugin for my project.
https://datatables.net/examples/api/row_details.html

I am able to convert my CSV to JSON format and display columns A to D as Rows in table and E to H as child rows(Please refere he attachment Test.jpg). But the problem is with data irregularity. I want to display rows (E2 to H2)(E3 to H3)(E4 to H4)(E5 to H5) as child rows under 1st row of data and (E6-H6)(E7-H7)(E8-H8) as child rows under 2nd row of data and so on.

Is it possible to add loop while populating the data or is there anyway to generate JSON in the required format.

PS: very new to Jquery & JSON.

Many thanks