Get a value from differerent columns

Hi All,

I have column A which contains a mix of 0s and 1s.

Column B contains a mix of 0s and 2s.

I kindly need a column C which pulls all the 1s and 2s from col. A&B.

Any suggestion?

Many Thanks,

Gaetano

Accepted answers

Can you try this formula it might be type issue.

IF ToNumber([Flag])!=0 THEN [Flag] 
ELSEIF ToNumber([Flag2])!=0 THEN [Flag2] 
ELSE Null() ENDIF

Hope this fixes. Feel free to reach out if it doesnt fix.

Can you provide some sample data.

Thanks

Please see attached, thanks very much.