#5, atomize
Great advices and many instructives comments !
Further to atomize, I split dates into separate columns of days, months, and years. Otherwise whenever changing country, dates are transformed into varied formats DDMM or MMDD or whatever. Import-export dates from text files further can be particularly troublesome. The trick to overcome Excel's automatic date formatting is arcane, I ended up atomizing the dates.