Get all elements from a json object at once

Hi guys,

thanks for the tremendous help of Kyle123, here on this forum, I'm able to pull JSON data and parse it onto a sheet.
The snippet of code I use for this is as follows:

Please Login or Register  to view this content.

This works fine, but loops through 60 'header elements' per row.
I'm pulling 100 rows of data now, so that's 100 x 60 loops. And it's slow.
However, I aim to pull 1000s of rows of data, which will take forever.
Is there any way that I can put all elements in a json row immediately into an excel row? Without having to loop 60 times through it?

Would speed up the code tremendously, so all help is very much appreciated!

Thanks,

Jasper

Subtle bump...