I have the below example where I have 3 columns in “CONDITION”
If I have data in all the 3 columns then the results should be column2 and column3 as shown in fig.
I used the below formula for “Results with my formula”
=IF(AND(NOT(ISBLANK($A2));NOT(ISBLANK( $B2));NOT(ISBLANK( $C2)));CONCATENATE( $B2; $C2)
But, I need the results as in “Expected Results” column
In case if the value in the above row is empty then the current value has to be posted in this cell.