merge two columns into one, Part 2
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
alpedhuez
am 11 Jun. 2020
Kommentiert: alpedhuez
am 11 Jun. 2020
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.
0 Kommentare
Akzeptierte Antwort
madhan ravi
am 11 Jun. 2020
Bearbeitet: madhan ravi
am 11 Jun. 2020
nansum([A, B],2)
%or
sum([A, B],2,'omitnan')
5 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!