Well, just press Refresh.
Formula:
let
Fonte = Excel.CurrentWorkbook(){[Name="Table"]}[Content],
#"Texto Aparado" = Table.TransformColumns(Table.TransformColumnTypes(Fonte, {{"Postcode", type text}}, "pt-BR"),{{"Name", Text.Trim, type text}, {"Fulladdress", Text.Trim, type text}, {"Municipality", Text.Trim, type text}}),
#"Dividir Coluna por Delimitador" = Table.SplitColumn(#"Texto Aparado", "Fulladdress", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Fulladdress.1", "Fulladdress.2"}),
#"Dividir Coluna por Delimitador1" = Table.SplitColumn(#"Dividir Coluna por Delimitador", "Fulladdress.1", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Fulladdress.1.1", "Fulladdress.1.2"}),
#"Colunas Mescladas" = Table.CombineColumns(Table.TransformColumnTypes(#"Dividir Coluna por Delimitador1", {{"Postcode", type text}}, "pt-BR"),{"Fulladdress.1.2", "Fulladdress.2", "Postcode"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Postcode"),
#"Colunas Renomeadas" = Table.RenameColumns(#"Colunas Mescladas",{{"Fulladdress.1.1", "Fulladdress"}})
in
#"Colunas Renomeadas"
Bookmarks