Calculated table with columns based on the values from another table

Hi,   Does anyone know how I can transform next table which is data source to the second table shown below. This is my data source. As you can see, there are multiple rows referring to the sam tra...