Rmove duplicate data inside a cell with power query

[redcom2086]

Hi, 

I´m triying to remove duplicate data inside a cell from a column with power query but I don´t get it. Data have this format:

Cell 1
10.2.121.77_[00:50:56:ac:71:53#254]
10.2.121.70_[00:50:56:ac:71:53#254]
10.2.121.77_[00:50:56:ac:71:53#254]

Cell 2
10.2.121.108_[00:50:56:b3:15:10#254]
10.2.121.108_[00:50:56:b3:15:10#254]

each line have the same format and each line is separated by carriage return.  I need to remove the duplicate value and left only the uniques values, the result should be:

Cell 1
10.2.121.77_[00:50:56:ac:71:53#254]
10.2.121.70_[00:50:56:ac:71:53#254]

Cell2
10.2.121.108_[00:50:56:b3:15:10#254]

how can I get that with power query? 
thanks in advanced

[camargos88 · Accepted solution]

Hi @redcom2086 ,

Try this one with a custom column:

Text.Combine(List.Distinct(Text.Split([Column1], "#(lf)")), "#(lf)")

You can try it with #(cr) as well.

[redcom2086]

thank you very much, it works!