Showing results for 
Search instead for 
Did you mean: 
webportal Member

Power Query: Expand a list of cells with tables

I have this big table with a column with tables in each row.


How can I expand each cell into a new table without having to manually click on each "Table" link using Power Query?




One option would be to create a reference of this main table for each of the cells and then click the "Table" link, but there must be a way to make the process easier.

Super User
Super User

Re: Power Query: Expand a list of cells with tables



If I got your question correctly, you can do like this



webportal Member

Re: Power Query: Expand a list of cells with tables


Thanks, but that gives me one table only, I need one separate table for ech row.

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 63 members 1,309 guests
Please welcome our newest community members: