Expand Table into Power query from column data get lost

Copper Contributor

Screenshot 2022-04-13 035315.pngScreenshot 2022-04-13 035435.pngScreenshot 2022-04-13 035502.pngHi, 


I am trying to expand table from Column. When I expand my table data get lost. I can only able to see 20 raw of data instead of 400. I want to split table into two separate column. 

can someone help to get all data during expand of table. 

1 Reply


If you share what is in cell with table for row #23 before splitting and what exactly error says (click to the right side of cell with error) it could be more clear.