IF formula when column A is Blank, populate with Column B, update column B With blank

[Masond3]

Hi All, 

I have such a basic ask, but i am struggling to write the correct formula. 

I have two columns, i am trying to write a simple formula that does the following ; 

if column A is "blank" & column B is "not blank", then populate  Column A with  column B 

Then Remove value from Column B

Input 

Column A	Column B
	123 High Street

Expected Outcome 

Column A	Column B
123 High Street

I have used the  following formula ;

If isnull([Column A]) then [Column B] else [Column A] endif

Current output 

Column A	Column B
123 High Street	123 High Street

[DataNath]

Hey @Masond3, you can just add a second expression like so that will empty out (null) the second column. Input:

Output:

[Masond3]

@DataNath  That would populate for anything in column B, is there a way it can only populate for those records in expression 1 ?

[binuacs]

@Masond3 One way of doing this by assigning the value of B to a temporary variable

[Christina_H]

Simplest way would be to clear column B if it's the same as column A after the first formula.

IF [Column B]=[Column A] THEN Null() ELSE [Column B] ENDIF

[Masond3]

Hi @Christina_H  - that makes sense :)

Daft question, if i want to apply the formula to only work in  x circumstances ( how do i apply more logic) 
example 
 if column c = New york, 

and  column A is "blank" & column B is "not blank", then populate  Column A with  column B 

Then Remove value from Column B

[Christina_H · Accepted solution]

You can use AND / OR in formulas to extend the logic.  An exclamation mark can be used for NOT.

IF [Column C]="New York" AND IsEmpty([Column A]) AND !IsEmpty([Column B]) THEN [Column B] ELSE [Column A] ENDIF

[Masond3]

@Christina_H  Super Star ! hopefully this help me some of the issues i am encountering :)