Issues in "Remove Duplicates"

Hi Thulasiraman ,

Here's a function from this link.

(text as text, optional char_to_trim as text) =>
let
char = if char_to_trim = null then " " else char_to_trim,
split = Text.Split(text, char),
removeblanks = List.Select(split, each _ <> ""),
result=Text.Combine(removeblanks, char)
in
result

Please go to the power query editor. Create a blank query, then enter the above code in the advanced editor.

Then you can add a custom using this function.

Now you can remove the column with the wrong spaces, keeping your new column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.