Create Excel Pivot / Summary Table

Need somebody to create a complex pivot table in MS Excel. Can use VBA code if necessary.

Data consists of a list of individual cases, one row per case, with their date, "risk" value, and a variable list of "codes" per case.

Want a summary pivot table that shows the "risk" values as rows, the "codes" as columns, and the count of how many of each code appeared in cases with each risk level as the values.

Will attach an Excel file showing the source data, and a mocked-up example of the desired summary/pivot table. However here is the same data:

Source data:

Case # Date Risk Codes
FE0000030 17-Mar Low No codes
FE0000031 18-Mar Low 4090 1802
FE0000032 21-Mar Medium 1802 2101 1520 1540
FE0000033 21-Mar High 1101 1520 1540 1802 2101 4090
FE0000034 23-Mar High No codes
FE0000035 23-Mar Medium 1802 2101
FE0000036 23-Mar Medium 1520 1540 4090
FE0000037 24-Mar Low No codes
FE0000038 24-Mar Medium 2101
FE0000039 24-Mar Medium 2101
FE0000040 25-Mar Low 1520 1101

Desired pivot table:

1101 1520 1540 1802 2101 4090
Low 1 1 1
Medium 2 2 2 4 1
High 1 2 1 1 1 1

2 4 3 4 5 3