Summing value with 2 parameters - Index & match, or Vlookup?

Hi, Hope someone can help point me in the right direction.

Have tried Index & match and had little joy, so need to ask the experts.

I have data in a table, and I need to look up values based on a code, and a split of that code.

Data example :

Code PMXU Value
112 P 1
112 P 1.5
112 M 1.5
113 U 1
113 U 1.2
114 X 1.5
114 P 1
114 P 2

I need to arrange the data in the following format :

Code P M X U Total
112 2.5 1.5 0 0 4
113 0 0 0 2.2 2.2
114 3 0 1.5 0 4.5


Any help is greatly appreciated!