title: Concatenate multiple columns in Excel?
body: <p>If column A contains</p>
  
  <pre><code>blue
  red
  green
  yellow
  </code></pre>
  
  <p>and column B contains</p>
  
  <pre><code>fish
  dog
  cat
  horse
  </code></pre>
  
  <p>what would be a formula to put the following in column C?</p>
  
  <pre><code>bluefish
  bluedog
  bluecat
  bluehorse
  redfish
  reddog
  redcat
  redhorse
  greenfish
  greendog
  greencat
  greenhorse
  yellowfish
  yellowdog
  yellowcat
  yellowhorse
  </code></pre>
  
  <p>I looked at using a PivotTable, but it didn't work using columns from different sheets in the document.</p>