Merging datasets in a spreadsheet
Here´s the scenario: you have two related datasets. Let´s say one is a list of name 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 should be able to merge the two, right? You´d be surprised at how difficult some folks find this. Well, I´m here to tell you, it´s surprisingly easy. Read the rest of this entry »