Updating a Value in a Column

[SR]

HI All,

I have a data set where i am trying to update particular values thats missing manager name as per those values in the same column that include a manager name.

Level 2	Level 3
SALES (ROB)	SALES 1 (BOB)
SALES	SALES 1
FINANCE (John)	ACCOUNTING (CARL)
FINANCE	ACCOUNTING

In the above table, i want to update the values "SALES" to "SALES (ROB)" or FINANCE to FINANCE (John)  . How do i do this.  I tried splitting the columns but i am unable to get the manager name associated to the rows where the entry is missing.

Thanks

SR

[Kenda · Accepted solution]

Hey @SR! Try using the attached workflow. The key was to use a Filter then a Formula and the Find and Replace tool. You could also replicate this if you wanted to perform the same actions to the Level 3 field. Does this work for your purposes?

[jrgo · Accepted solution]

Hi @SR,

See if the attached example provides you with what you're looking for.

Regards,

Jimmy

[SR]

this is perfect. Thank you so much. you been so helpful!!!