cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
webportal Member
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?

 

Capturar.JPG

 

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.

2 REPLIES 2
Super User
Super User

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

@webportal

 

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

 

expand.png

webportal Member
Member

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

@Zubair_Muhammad

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