Forum Discussion
Rmove duplicate data inside a cell with power query
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
Hi Anonymous ,
Try this one with a custom column:
Text.Combine(List.Distinct(Text.Split([Column1], "#(lf)")), "#(lf)")
You can try it with #(cr) as well.
2 Replies
Hi Anonymous ,
Try this one with a custom column:
Text.Combine(List.Distinct(Text.Split([Column1], "#(lf)")), "#(lf)")
You can try it with #(cr) as well.