Hi All.

Sorry for the poor title, really struggling with how I need to word this. I have a table where records are continuously added which both contain the name of an individual and then a series of codes. The same individuals will appear many times, but the codes that they are assigned often fluctuate, change position, can be duplicated, and are taken from a list of circa 10,000.

I've tried to simplify what I mean using the table below.

Name Code 1 Code 2 Code 3
Harry A B C
James C E E
Harry D C A
Ben A E B

I want to be able to count (ideally using formuale) the number of times that each individual has each code recorded against them. Ideally in an output similar to the below table:

Name A B C D E
Harry 2 1 2 1 1
James 0 0 1 0 2
Ben 1 1 0 0 1

Any help is greatly appreciated