I need to create a spreadsheet that shows the same date 24 times then moves to the next date.
For example -
Is there a way to insert it automatically or autofill it? (I have to produce two years worth of data)
If ignore Other column and Date, Time are located as
type in A3
select columns A and B starting from above cells and till end of your expected range, Ctrl+D.
Or drag them down.