I have a speadsheet with column A and B look like

`A BNaN 11 NaN2 NaNNaN 3`

Then I want to create a column C

`c1123`

That is, the value of column C is the value of A if A is nonempty and the value of B if A is empty. Please advise.

## Best Answer