I need to populate the empty columns with corresponding values within that year, it could be that I have to repeat the entry of the values (for instance fill up 2004 with the same values-128, 2005-130, 2006-130, 2007-127). Any suggestions of the right code to use? This is just an example, I have observations of over 6 million: 24 countries,
year country GDP
2004 SE 128
2004 SE
2004 SE
2005 SE 131
2005 SE
2005 SE
2006 SE 130
2006 SE
2006 SE
2007 SE 127
2007 SE
2007 SE