title: How to combine two columns into one base on conditions in excel
body: <p>I am new to Excel. This might be really basic...Please help</p>
  
  <pre><code>Column1 Column2
  A         B
  C         D
  E
  F
  G
  </code></pre>
  
  <p>The rule is if Column1 and Column2 are both not blank, get the values of Column2.
  so the new columns will be:</p>
  
  <pre><code>Column3
  B
  D
  E
  F
  G
  </code></pre>
  
  <p>Thanks!</p>