Power Query - Blank Cell = Cell of Another Column

[Gsrgofass]

Hello,

In power query, I have a partially populated column A.
I would like to populate Column C using statements:

=IF [Column A] has an entry, then fill [Column C] with that information.
=IF [Column A] is null or blank, then fill [Column C] with [Column B] information

Resulting in Column C having all cells populated.

BEFORE

AFTER

Thank you

 

[alansidman]

=if [Week 1]= null then [Week 2] else [Week 1]

In Add Column, set the column name to Work Done and then apply this line of code