Represent Data With The Similar Column Values To One Row?

I am looking for the way to represent data with the similar column value to one row.A query retrieves 3 records AS IS, but I need one record.

Table:

Name / 1 year / 2 year /3 year

AS IS

Name 1 year 2 year 3 year

1 John Smith A
2 John Smith B
3 John Smith A+
=================================

TO BE

Name 1 year 2 year 3 year

1 John Smith A A+ B