Help Transforming Data for further Analysis

Hi I am working on transforming my input data for further analysis I am trying to achieve the following:

Goal:

with the current data:

I have tried using the unpivot but for some reason the numbers are coming out incorrect. Thanks in advance!