Filter and select specific text in Column A select and Not Null in Column B now copy data from column B and Paste (overwrite) in Column C AB (Selected Not Null)C (Overwrite here)My Payment1068210682My Payment8202182021My Payment641641

Filter & select specific text in Col A select and Not Null in Col B and Paste in Col C

Filter and select specific text in Column A select and Not Null in Column B now copy data from column B and Paste (overwrite) in Column C

Workflow

Output

Expression

Maybe you like this ?

IIF([A] = 'My Payment' && !IsEmpty([B]), [B], Null())

@Rajesh your requirement is confusing. can you elaborate little bit more?

in Column A it should Select "My Payment" and go to Column B Select Non-Blank and Move a copy of records from Column B to Column C

Maybe you like this ?

IIF([A] = 'My Payment' && !IsEmpty([B]), [B], Null())

Hi @flying008 I am new to this tool... Thank you! its working perfectly fine. 😊