Build a google sheet report

I will provide the data and the idea is to create a report from this data thats update whenever a form is completed.
See attached image being the first about the availabe data and the second the example of the report that i want.
thank you.