Replacing value in a column
I am trying to conditionally replace value in 2 columns in a table below. For example if fruit is mango replace color to black and quantity with 10.Is there an easy way to do this? Fruit Color QuantityApple Red 1Mango Yellow 2Orange Orange 3Banana Yellow 2Grape Green 1