How to deal with multiple data types in a column: some rows are tables and others text

The ones with tables have values, shown on the preview. I can only drill down or add as new query. How do I get the values from the tables