Using Excel 2007

I have information in columns A, B and C as shown below:

A B C

Bob 5
Steve 4
Bob X
John 7
John Y
Ron 8


I would like to combine similar entries in column A into one entry (one
line) in column A and with the corresponding values in columns B and C on one
line as shown below:

A B C

Bob 5 X
Steve 4
John 7 Y
Ron 8

I would like to do this in the simplest way possible and without using a
macro.

Any suggestions are appreciated.

Thank you,

Bill