Formatting for a new data display

Hi,

My data currently looks like this: 2iiaRXl.jpg

I would like some help to render it into something like this: TZ1ibNb.jpg

I tried to use pivot tables but I couldn't get it to look right: Jyn1CKl.jpg. If possible, I want the companys' ratings to be displayed along each corresponding year row, similar to the picture in the second link.

Thanks.

Thank you so much. This worked perfectly!!

+rep