Formula that helps me reformat data.

Hello,

I was wondering if someone could give me a formula that would help with transfering one data format to another. In the first image i have a set of data http://imgur.com/a/2V0sn i have highlighted it in red and green. I need a formula that helps me turn it into this format. http://imgur.com/EFzpO9g

Thank you