Do some Excel Work -- 2

I have 2 CSV files that i would like combined into a single XLS and re-formatted. Use the May file for historical data, and then supplement this with the August data i.e. August file only to be used from May-Aug 2017. I would like all columns clear in the XLS e.g., date, time in bed, sleep quality, notes (all notes need to be separated so it's easy to identify notes on each date). In terms of outputs, I would like a simple line chart showing sleep quality over time, and a summary table showing number of days each note was recorded eg how often have i 'worked out', 'drank coffee', etc. Expect this to take 2-3 hours. Main tasks are: 1) text to columns; 2) columns to be displayed are: date, sleep quality, time in bed, bedtime, wake-up time (End), notes (all notes to be separated in separate columns) with ticks for night when they are applicable; 3) hide redundant columns; 4) ensure all dates, numbers correctly formatted