if cell has a number delete row

Hi Syndicate_Admin 

Place the following M code in a blank query to see the steps.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWSgSTRmAyCUwag8lkpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Duplicated Column" = Table.DuplicateColumn(Source, "Column1", "Column1 - Copy"),
    #"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"Column1 - Copy", type number}}),
    #"Kept Errors" = Table.SelectRowsWithErrors(#"Changed Type", {"Column1 - Copy"}),
    #"Removed Columns" = Table.RemoveColumns(#"Kept Errors",{"Column1 - Copy"})
in
    #"Removed Columns"

 

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.