Expand Table into Power query from column data get lost

[akashkapatel]

Hi, 

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. 

[#2]

@akashkapatel 

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.