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

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!

Input

Power BI

Accepted answers

All comments

Emil_Kos

Hi @gavinloi,

this is the formula that you need to use:

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

Please see the workflow attached.

Formula.yxmd

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 🙂

fill empty.yxmd

Emil_Kos

Hi @atcodedog05,

Long time no see 🙂

Cookie monster is back 😄

gavinloi

Many thanks! It works 😀

gavinloi

Many thanks!😀

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703