Remove duplicates

[sericson]

hello! how can we remove duplicates that are caused from concatenating, it doesn't occur in every row. below is an example of what is happening. 

[DataNath]

Hey @sericson, I'd split out the values, leverage the Unique tool to get rid of duplicates and then re-concatenate those left. The other tools such as the Sorts and Tile are just ensuring everything stays in the original order. Here's an example of the start end end result: