Filter and only keep list

[Anonymous]

Working with json, a column gives mixed data. How can I isolate the "List"s from the remaining lines? One way is to unselect all in the filter. It works for some reason, but is not dynamic. I've tried putting null, [List] and "", but was not succesful. Also is there a specific name/term for this "List"? 

Intended result:

Data from AZURE Cognitive Service

[wdx223_Daniel · Accepted solution]

=Table.SelectRows(#"Changed Type",each [Value] is list)

[mahoneypat]

Based on your pic, you can now add an Index column, then a Modulo column, and then filter to just the rows with the Lists.

Or you can provide some of the JSON text, so a specific solution can be provided.

Pat