As I am working with 1000 number of id and value, I want to concatenate the id and value if two values are same and make a new column as data… else leave as it is
Given:
id value data
1 abc
2 abc
3 abc
4 def
5 def
6 ghi
Expected Result
id value data
1 abc abc
2 abc 2-abc
3 abc 3-abc
4 def def
5 def 5-def
6 ghi 6-ghi
Friends please help me in finding the solution for this…
Thanks in Advance.
Praveen