title: Join two spreadsheets on a common column in Excel or OpenOffice
body: <p>I have two CSV files with a common column and I want to "Join" the tables together on the common column. </p>
  
  <p>For example: Join 'A' with 'B' equals 'Result'. If a one table has a key value that does not exist on in the other table its just left as blank. </p>
  
  <pre><code>== Table A ==        == Table B ==        == Table result ==
  Name  ,Age           Name  ,Sex           Name ,Age ,Sex
  Bob   ,37     +      Bob   ,Male     =&gt;   Bob  ,37  ,Male
  Steve ,12            Steve ,Male          Steve,12  ,Male
  Kate  , 7                                 Kate , 7  , 
                       Sara  ,Female        Sara ,    ,Female 
  </code></pre>
  
  <p>I know how to do this with an SQL database but I have never done it with "Excel" or "OpenOffice.org Calc"</p>
  
  <p>Suggestions? </p>