Trim spaces, fix capitals, turn text into numbers and dates, split and merge columns, and delete blank rows.