Iterate over date table to autogenerate missing dates with values associated
I have a table that I have loaded from an excel file. This table contains quarters for each year:
Date A B
01/01/2009 34 100
01/04/2009 12 80
01/07/2009 58 20
01/10/2009 24 10
01/01/2010 56 23
01/04/2010 14 40
01/07/2010 9 79
01/10/2010 20 120
and I want to obtain below table:
Date A B
01/01/2009 34 100
02/01/2009 34 100
03/01/2009 34 100
04/01/2009 34 100
....
01/02/2009 34 100
02/02/2009 34 100
03/02/2009 34 100
...
01/04/2009 12 80
02/04/2009 12 80
03/04/2009 12 80
...
01/06/2009 12 80
02/06/2009 12 80
...
01/07/2009 58 20
02/07/2009 58 20
..
01/09/2009 58 20
02/09/2009 58 20
...
01/10/2009 24 10
02/10/2009 24 10
03/10/2009 24 10
04/10/2009 24 10
...
01/11/2009 24 10
...
01/12/2009 24 10
..
01/01/2010 64 30
02/01/2010 64 30
Note that each time a quarter for a year starts I need to autogenerate next dates and repeat values for columns A and B until to reach next quarter. Once next quarter is reached I should begin to repeat new values for columns A and B until next one, and so on.
