211142_en-US

liliconcom

How to combine two columns (with missing data)?

got a table with missing data like this:

Column1	Column2
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!

 

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

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