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

[Rajesh]

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

A	B (Selected Not Null)	C (Overwrite here)
My Payment	10682	10682
My Payment	82021	82021
My Payment	641	641

[binuacs]

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

[Rajesh]

@binuacs

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

A	B (Selected Non-Blank)	C (Overwrite here)
My Payment	10682	10682
My Payment	82021	82021
My Payment	641	641

[flying008 · Accepted solution]

Hi, @Rajesh 

Maybe you like this ?

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

[Rajesh]

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