Count occurrences of User ID

[chonchar]

Good morning,

I have a table called "October '23."

I have a list of about 114k entries. I need to count how many times Guy 1, Guy 2, Lady 1, etc occur in the table based on their user ID. Below is my expected output. 

Thank you, 

@parry2k help me please, or anyone else!

Best, 

Cam

[mickey64 · Accepted solution]

For your reference.

I make a matrix below.