Transforming data

Hi, can anyone help me with ideas how to transform first table into the second one? thank you so much in advanced !!!