My data has quite a few instances where the rows are duplicate, but the values are just mirrored in different columns. I want to remove the duplicate instance and keep the original. For example, if row1 = x y and row2 = y x I want to get rid of the second row but keep the first.
Solved! Go to Solution.
@sgibson34
find the workflow attached
mark done if solved.
I could use this if i could concatenate the data from the two columns together, how would i do that?
@sgibson34 find the updated workflow
mark done if solved.