What I need to do is insert blank rows of data for every quarter hour slot within each day where no data is held. in other words, when no telephone calls were received.
An extract from the data I have at the moment, is shown below:
Code: Select all
CALL_QTR_SLOT, CALL_HALF_HR_SLOT
1,1
5,3
9,5
13,7
17,9
Any suggestions ?