Samuel Oranyeli has a great blog series on munging spreadsheets. Lots of practical advice for those who are interested in practical wrangling of messy spreadsheet data that come to us from collaborators.