Need help with JSON in Power Query

[cleverclog]

Hello all,

Please forgive me if my post does not sound very professiona as I am quite proficient in Power Query when I extract data from local sources, but this time I have faced a REST API and got a bit lost.

I have connected through a REST API and receive data in JSON format. Surprisingly, I have a separate list of headers and a separate list of rows. A list of rows contains 26 lists (which is the number of items in my database for a selected period) and this time every list contains 87 records (which corresponds to the number of columns in my table).

My issue is that I do not know how to combine all those records and transpose them before I expand the column with lists. Otherwise, I get all the values stacked in a column view instead of 26 rows of 87 columns.

Screen capture

I will sppreciate if you could guide me a little bit with this issue.
Thanks
Lukas

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need help with JSON format data pulled through API
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[cleverclog]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need help with JSON format data pulled through API
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

OK, sorry. I was desperate to find the solution but I managed to do it myself.

 

[Joe4]

OK, sorry. I was desperate to find the solution but I managed to do it myself.

As we said, it is OK to Cross-Post here, provided that you follow the guidelines for doing so.

Also, if you have a solution to your problem, could you post it back here to the thread?
We like this forum to be a searchable database, so if others have a similar issue and come across this thread, they can find the answer.

Thanks