Category Archives: spreadsheets (Excel or Calc)

How to merge data in an Excel or Calc spreadsheet, part two

By Dposorio | Published: July 25, 2009

This post is a continuation of an earlier one detailing how to merge datasets in Excel or OpenOffice’s Calc. A reader, Tina, asked “What if you have more than one column to lookup to get the match value?” This post is a response to that question. A merge of two datasets requires at least one [...]

Posted in spreadsheets (Excel or Calc) | Tagged , , , , , , , , , , , , | 1 Comment

How to merge data in an Excel or Calc spreadsheet

By Dposorio | Published: April 19, 2008

Here is the scenario You have two related datasets in Excel or OpenOffice’s Calc. One is a list of names with phone numbers, and the other is a list of names and email addresses. The two datasets have a unique id in common (like a Social Security number). You want to merge the two of [...]

Posted in spreadsheets (Excel or Calc) | Tagged , , , , , , , , , , , | 7 Comments