title: Merging data in Open/LibreOffice Calc
body: <p>I have two sets of data in .csv format which share a field called <code>sku</code>. The second one has additional columns which need to be added to the first, but they have different sets of data, only some of which overlaps.</p>
  
  <p>The only data that needs to be merged is for <code>sku</code>s that already appear in the first. For example:</p>
  
  <p>File 1</p>
  
  <pre><code>sku,foo
  a,hello
  b,world
  </code></pre>
  
  <p>File 2</p>
  
  <pre><code>sku,bar
  a,0
  b,1
  c,2
  d,3
  </code></pre>
  
  <p>would result in:</p>
  
  <pre><code>sku,foo,bar
  a,hello,0
  b,world,1
  </code></pre>
  
  <p>Is this possible?</p>