cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
jasongao
Level II

How to combine two columns (with missing data)?

got a table with missing data like this:

Column1Column2
1
5
7
3

 

Need to combine it it to one column

 

Column3
1
5
7
3

 

I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it? 

Thanks!

 

1 REPLY 1
jasongao
Level II

Re: How to combine two columns (with missing data)?

OK. I figured out. I need to use sum() instead of +.