How to explode nested list items?

[Anonymous]

Of the four rows one of them is a List. Drilling down this list gives 15 rows of "Record". Drill down this "Record" gives another set of rows which has a "Record" and drilling down this to fet the final set of data. All of this drilling down is for one item only. I have to manually drill down all the items which is not possible.  The icon of "two opposite arrows" to show all the data does not appear here.

I want to select some columns from the each drilled down level and make one table. this table should have the following columns, 

item_number - showing all the item numbers from all the nested levels

Quantiy - from level 2

major rev - from level 3 

Attached is the screenshot 

[lbendlin · Accepted solution]

There is no magic to it. You are trying to fit a round hole (JSON hierarchy) into a square peg (Power Query table). The only way is a manual way, and you need to make decisions and compromises along the way to decide what to flatten and what to discard.

[Anonymous]

Well, could have done without the sarcasm but still thanks for the reply. It helped.