Hi!
I have one big table with 3 columns (Name, Year, Data Value). For each name I have values for some years but not for all (from 2010 to 2014). I must extend the table with each year for each Name, and where there are not value I must enter 0 (zero). Below is example.
Existing table:
Name Year Value
CD1 2012 5
CD1 2013 8
CD2 2011 3
CD2 2012 6
Table which I need:
Name Year Value
CD1 2010 0
CD1 2011 0
CD1 2012 5
CD1 2013 8
CD1 2014 0
CD2 2010 0
CD2 2011 3
CD2 2012 6
CD2 2013 0
CD2 2014 0
Is possible to do that automatically?
Bookmarks