How to normalize table with multiple similar columns (day1, day2, day3...)?
The better way is the original design with 1 column for Date, From and To.
If data is large size than you can partition the table on the basis of date(month wise or day wise).

ID, Date, From, To, Location