Why don't they teach us how to prep the numbers as well as how to crunch them?
March 26, 2012 12:08 PM Subscribe
ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!)
posted by smirkette to computers & internet (10 answers total) 4 users marked this as a favorite
- Data is in three different spreadsheets, reflecting three different instances of data collection
- Each new spreadsheet should append its column contents (maintaining its original column headings) to a “master” spreadsheet
- There is a column that we can use as a unique ID that could function as a primary key (I think?)
- Not all unique IDs are guaranteed to show up in all three spreadsheets (subjects may have missed one or two data collection days).
This is for a relatively small set (N=~150) but I’ll need to do the same thing with a much, much larger dataset in the coming month (N=15k+), so a brute force copy-paste won’t be feasible. I’m sure there’s got to be a smarter way of doing this. I have no database experience, but I can get my hands on Access and teach myself if you can point me to what kinds of topics I should be looking at.
I’ve tried asking around locally without success (still waiting to hear back from the research help folks) and my Google-Fu is failing. Thank you!