Column Replacement

[VamsiKrishna05]

Hi Team,

I need small help 

I have 2 columns

C1 | C2 

A    | aa 

B    | ab

C    | ac

D    | ac 

E.   | ad

Now i need to replace C2 value in C1 ( where C2 = ac those values i need to replace in C1 ). And i need show only the ac value in the table, i don't want show remaining data like aa, ab, ad in C1.

please suggest me some steps.

[abhijitnalekar]

Hi @VamsiKrishna05 ,

Is it possible to explain the scenario with the help of excel?

[VamsiKrishna05]

Thanks bro, i got an idea 

So i resolved it , i done the changes in data model using where exists