let
    Source = AllContentReport,
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([LinkURL], "%20")),
     #"AllReplace" = [
        #"–" = "-",
        #"’" = "'",
        #"%20" = " ",
        #"%22" = """",
        #"%21" = "!",
        #"%23" = "#",
        #"%24" = "$",
        #"%25" = "%",
        #"%26" = "&",
        #"%27" = "'",
        #"%28" = "(",
        #"%29" = ")",
        #"%2A" = "*",
        #"%2B" = "+",
        #"%2C" = ",",
        #"%2D" = "-",
        #"%2E" = ".",
        #"%2F" = "/",
        #"%3A" = ":",
        #"%3B" = ";",
        #"%5B" = "[",
        #"%5C" = "\",
        #"%5D" = "]",
        #"%5F" = "_",
        #"%7F" = " ",
        #"%E2%80%9A"=",",
        #"%E2%80%99" = "'",
        #"%E2%80%9C" = """",
        #"%E2%80%9D" = """",
        #"%E2%80%93" = "-",
        #"%E2%80%94" = "-",
        #"%E2%84" = "™",
        #"%C5%93" = "œ",
        #"%C2%A0" = " ",
        #"%C2%AB" = "«",
        #"%C2%B4" = "'",
        #"%C2%BB" = "»",
        #"%C3%80" = "À",
        #"%C3%81" = "Á",
        #"%C3%88" = "È",
        #"%C3%89" = "É",
        #"%C3%A0" = "à",
        #"%C3%A1" = "á",
        #"%C3%A6" = "æ",
        #"%C3%A7" = "ç",
        #"%C3%A8" = "è",
        #"%C3%A9" = "é",
        #"%C3%AA" = "ê",
        #"%C3%AE" = "î",
        #"%C3%B2" = "ò",
        #"%C3%B3" = "ó",
        #"%C3%B4" = "ô",
        #"%C3%B9" = "ù",
        #"%C3%BA" = "ú",
        #"%C3%AD" = "í",
        #"%C3%BB" = "û",
        #"%C3%A2" = "â",
        #"%C3%AF" = "ï",
        #"%40" = "@",
        #"%C3%B1" = "ñ",
        #"a%CC%80" = "à",
        #"e%CC%80" = "è",
        #"e%CC%81" = "é",
        #"a%CC%82" = "â",
        #"i%CC%82" = "î",
        #"  " = " ",
        #"/:b:/r" = "",
        #"/:p:/r" = "",
        #"/:x:/r" = "",
        #"/:w:/r" = "",
        #"/:i:/r" = "",
        #"/:v:/r" = ""
    ],

    #"Replaced Value" = Table.TransformColumns(#"Filtered Rows",{{"LinkURL",each Record.FieldOrDefault(AllReplace,_,_)}})
in
    #"Replaced Value"