Pivot a row for two columns

Hello all, Can someone plese help me with the code how to get from Table 1 to Table 2 please?  Pivot fucntion is needed but i cant figure out exact code.  Thank you in advance.   Table 1: prod...