Forum Discussion

nheller's avatar
nheller
New Member
8 years ago
Solved

Replace values in one column with a conditional referencing another column

I have two columns: 'Partner Name' and 'Client Name'. Each time a particular value in 'Partner Name' is referenced ('xyz'), I'd like to replace the corresponding null in 'Client Name' with a new valu...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi nheller,

     

    You could create a new 'Client Name' column, then, remove the original one.

     

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi nheller,

 

You could create a new 'Client Name' column, then, remove the original one.

 

 

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-yulgu-msft 

What should be written under "Else" if I wish the values to remain the same, if the specified conditions above are not met?

 

thank you!