I have data like this in a (CSV) spreadsheet:. It is actually much longer than this example.
2000,15
2002,24
2005,18
How can I put in the missing years to have it continuous like this?
2000,15
2001,0
2002,24
2003,0
2004,0
2005,18
97061.ods (21.3 KB)
Drag down the 2000 in order to create the year sequence and apply a lookup formula with error handling.
2 Likes