Pivot data to column

I have this piece of data in rows format

Can anyone advise how could i change it to be column based? I have been trying using the PIVOT but PIVOT required to have the MAX.