Hi All
Looking for help on a big problem I have.
I have data for Depot departure times and store arrival times for each day in the week. In total there are 1892 deliveries for 304 stores accross the 7 days. I have tried to use a pivot table to take the data from a 1 column going down the sheet top ut all the data accross the spreadsheet showing the times for each day. The main problem is the data starts in the wrong day in the pivot table and because there may be 2 deliveries in the same day but at different ends of the day, it misses the 2nd delivery day out. Hope this makes sence and below is an example.
E.G
Saturday
Store: Depot Depart: Store Arrival:
ABC1 22:50 00:16
Sunday
ABC1 21:54 23:25
Because there are 2 deliveries in the Sunday it misses out the second depart/delivery data. The pivot table also puts some of the data in the wrong day when there are deliveries as above.
When delivery times are in each day, there is no problem.
Hope someone can help.
Looking for help on a big problem I have.
I have data for Depot departure times and store arrival times for each day in the week. In total there are 1892 deliveries for 304 stores accross the 7 days. I have tried to use a pivot table to take the data from a 1 column going down the sheet top ut all the data accross the spreadsheet showing the times for each day. The main problem is the data starts in the wrong day in the pivot table and because there may be 2 deliveries in the same day but at different ends of the day, it misses the 2nd delivery day out. Hope this makes sence and below is an example.
E.G
Saturday
Store: Depot Depart: Store Arrival:
ABC1 22:50 00:16
Sunday
ABC1 21:54 23:25
Because there are 2 deliveries in the Sunday it misses out the second depart/delivery data. The pivot table also puts some of the data in the wrong day when there are deliveries as above.
When delivery times are in each day, there is no problem.
Hope someone can help.