title: Excel, append one range to the end of another in one column
body: <p>I have two columns of data in Excel. I would like to add a third column which combines the first and second. How can I do this with a formula such that I can add or remove data from columns A and B without ever having to touch column C?</p>
  
  <pre><code>Column A  Column B  Column C
  Bob       Mary      Bob
  Joe       Melissa   Joe
  Jim       Jackie    Jim
                      Mary
                      Melissa
                      Jackie
  </code></pre>