How to open nested tables from power query, in new sheets?

Copper Contributor

In excel, I have a power query which loads a table with nested tables. In the query editor window, I can click the Table and drill down which is great.


Problem is, when I do save and close, and return to the regular excel view, and I see the table there, the nested tables, show as "Table" like a literal string. And if I click it, nothing happens, since it is just a string.

 

I would like it to open up the nested table in a new sheet for example.

 

How can I do this?

1 Reply