Excel 2007 : vlookup and transpose query

[breadpitt]

Dear All,

I am an excel newbie , I have data with following format:

sample
input.jpg

and this is the desired result:

output.jpg

is it possible to create macro or function to get the result?

Thank you in advance

Cheers