MATLAB: Merge two columns into one, Part 2

MATLAB

I have a speadsheet with column A and B look like
A B
NaN 1
1 NaN
2 NaN
NaN 3
Then I want to create a column C
c
1
1
2
3
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

  • nansum([A, B],2)
    %or
    sum([A, B],2,'omitnan')