let Source = crb3f_production_tracking_shipping, // Ensure the column is treated as text and handle null values #"Handled Nulls" = Table.TransformColumns(Source, {{"crb3f_void_fill_type", each if _ = null then "" else _, type text}}), // Define the list of uppercase words to remove UppercaseWordList = {"FOAM", "UNKNOWN", "TRAY", "BUBBLE WRAP"}, // Remove rows where the value is fully uppercase AND in the word list #"Filtered Rows" = Table.SelectRows(#"Handled Nulls", each not List.Contains(UppercaseWordList, [crb3f_void_fill_type]) ) in #"Filtered Rows"