Help please! I created the attached spreadsheet, but the person I sent it to has limited Excel knowledge and says that the rows with 0 days are confusing her. Is there a way that I can transpose the start and end times to the empty AM/PM/LATE columns according to which part of the route they are? I have over 4,000 rows in the master document so would like to not have to do it manually if possible. Or, if anyone has another idea on how to simplify this without a lot of manual work I would appreciate that.

Example of something along the lines of what I would like to end up with is in the second table at the bottom.Sample Data - Transpose.xlsx