Copy a column data from a column and pasting it into another column's empty cell

[gavinloi]

Hi all,

What I am trying to achieve is that by copying data from column A and pasting it into the empty cell's of column B without amending cells in column B that already has values.

Thanks!

[Emil_Kos]

Hi @gavinloi,

this is the formula that you need to use:

IIF(IsNull([B]), [A], [B])

Please see the workflow attached. 

[atcodedog05]

Hi @gavinloi 

This can easily achieved by formula tool.

Input:

Workflow & output:

The formula needs to applied on Column B (Target column). IsEmpty() checks whether the column is Null or blank. IIF() is a if else condition if column B is empty then column B else remain unchanged and keep column B.

Hope this helps 🙂

[Emil_Kos]

Hi @atcodedog05, 

Long time no see 🙂 

Cookie monster is back 😄

[atcodedog05]

Hi @Emil_Kos 

Yup has been a while 🙂

😜

[gavinloi]

Many thanks! It works 😀

[gavinloi]

Many thanks!😀

[Emil_Kos]

Hi @atcodedog05,

No cookies for us 🙂