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:
[ATTACH=CONFIG]57500[/ATTACH]
And I need to move the data like this:
[ATTACH=CONFIG]57501[/ATTACH]
These are just examples, the real sheet is about 1 year and on each day it runs from 09:00 to 04:00.