Unable to expande further

[TomaKavi]

I had several columns that have been expanded without a problem to a level that I need. But one of them reacted like this. Is there  a way how to expand it somehow ? As you can see the expand options is missing here.

[TomaKavi]

it was a simple expand like by others. The other colums are in good shape but as you can see, this was contians different types of values. The problem is that after expand it contains ,,table,, with several numbers which I can see in ,,details,, but cant extract. Any idea? 

[jennratten]

Hello - In order to expand, the cells must each have the objects needing to be expanded.  You can replace the null values with tables, like this:

Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type table) then _ else #table({“ExpandTableColumnName”}, {{_}}) }})

What steps were taken prior to this one?  What step produced the values such as 191EL?

https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...