How to transform grouped data?

Hi there, kinda difficult to explain what I want to get, therefore difficult to find something similar in forum, so I hope you can point me to the right stuff. To explain my point I'll prowide exampl...