Programming to format

[smhelp]

Hi,

Im pretty new to excel, can somebody help with this. I've attched a worksheet with how my input is and how my output should look like.

I want this do be done through programming. Is it possible. If so somebody please help.