Hi Experts,
Problem:- Find the Unique Values in Each Row.
Input:-
Col1
a,b,a
b,b,c,c,a,s
c,a/c,c,a/c,e
Output:
a, b
a, b, c, s
c, e, a/c
Here operation happens only on single column and find the unique values in a each row.
I am not sure how to perform this operation.
Any help appreciate .
Thank you
Solved! Go to Solution.
Hey @dondapati
If you add a recordid and split your column to rows (Text to Columns) then you can you use unique to remove the duplicates. Lastly summarize tool to concat the column back together again
@LordNeilLord we following each other round today? You beat me to it on this one.