Individual     YearDate   Value
17             2010       14
17             2011       -
17             2014        3
..
17             2016       7

Individual      YearDate     Value    Latest
    17             2010       14       7
    17             2011       -        7
    17             2014        3       7
    ..
    17             2016       7        7

SELECT Individual, (select TOP1 1 Value FROM table AS T1 WHERE T1.Individual=table.Individual AND t1.Value is NOT NULL ORDER BY Year DESC) AS Latest
FROM table ;