Dear All,
I have a data as below:
A B
1 apple red
2 apple green
3 lemon yellow
4 lemon green
How could I merge data to :
A B
1 apple red>>green
2 lemon yellow>>green
Thank you~