I'm stuck, I have a spreadsheet with date spanning across the top and vendor as well as count data running down the side for each day.
What I need is to combine the date and time and move the data accordingly.
For example I have this data:
And I need to move the data like this:
These are just examples, the real sheet is about 1 year and on each day it runs from 09:00 to 04:00.