Remove Rows if it contains text from any other another row

Hello supergenius123 ,

this is your code, to add in PQ

    #"Aggiunta colonna personalizzata" = Table.AddColumn(#"Rinominate colonne", "IsPrefix", (currentRow) =>
        let
            AllValues = List.Distinct(#"Rinominate colonne"[Value]),
            OtherValues = List.RemoveItems(AllValues, {currentRow[Value]}),
            IsPrefix = List.AnyTrue(List.Transform(OtherValues, (x) => Text.StartsWith(currentRow[Value], x)))
        in
            IsPrefix
    ),
    #"Filtrate righe" = Table.SelectRows(#"Aggiunta colonna personalizzata", each [IsPrefix] = false),
    #"Rimosse colonne" = Table.RemoveColumns(#"Filtrate righe", {"IsPrefix"})
in
    #"Rimosse colonne"

Let me know 😉