Turning a Vertical Table into a Horizontal one

Hi All

Im really struggling with something I know is relatively simple but im missing something in my H or Vlookups

Please see image link and attachment regarding what Im trying to do

Any help would be awesome

http://i.imgur.com/mpdKzg0.png