remove distinct values from row within a column

[jbbcormed]

I am trying to remove repeated values from a column
that has comma seperated values (Ex, 1,3,4,6,7,9,9,9,9) should return (1,3,4,5,6,9)

 I found a match for my issue on stack overflow, which works in the example format, but when I try to apply to my query, I don't understand how to reference a specific column from my source. Would anyone be able to demonstrate to me how to fix this syntax? Thank you. 

https://stackoverflow.com/questions/70576109/how-to-remove-duplicates-in-a-text-string-with-power-qu...

The example: 

let
Source = "Giang.Phan@abc.com, thao.tran@abc.com, Khoa.Vu@abc.com, Vn.Offset@abc.com, Giang.Phan@abc.com, thao.tran@abc.com, Khoa.Vu@abc.com, Vn.Offset@abc.com",
#"Distinct Values" = Text.Combine(List.Distinct(Text.Split(Source, ", ")),", ")
in
#"Distinct Values"

The example above works

My source contains multiple columns, so I tried to reference the column from source like this - 

= Text.Combine(List.Distinct(Text.Split(#"PREVIOUS STEP"{"MY COLUMN NAME"}, ",")),",")

let
Source = <A BUNCH OF COLUMNS HERE>,
#"Remove Duplicates" = Text.Combine(List.Distinct(Text.Split(Source{"MY COLUMN NAME"}, ",")),",")
in
#"Remove Duplicates"

[Greg_Deckler · Accepted solution]

@jbbcormed Try adding a custom column like this:

=Text.Combine(List.Distinct(Text.Split([YOUR COLUMN NAME], ", ")),", ")

You can then remove the original column.

[jbbcormed]

Oh my gosh, I don't know why that threw me for a loop, worked like a champ, this is like when I realize I should be doing a calculated column instead of a measure in DAX. "When it no worky, consider you are doing it in the wrong place" haha

Edit: And THANK YOU!