I have two data sets from separate sources - the first is monthly data and the second is quarterly data. I would like to blend the data to generate a simple viz that looks like rows one and three below. For example, the quarterly data established on 9/30/2012 is used for the months ending 10/31/2012, 11/30/2012 and 12/31/2012 - a new quarterly value is then established on 12/31/2012 and is used for the months ending 1/31/2013, 2/28/2013 and 3/31/2013 etc. etc.
Currently the viz looks like the first two data rows below - this result is "unwanted". What I would really like to see is the "desired" result on row three. Does anyone know how to do this?