Parsing and Counting Text Data?

Any thoughts on how I can parse and count the frequency of data in this format:


Control Names
123 Pryor, Mark; Bingaman, Jeff; Portman, Rob
345 Portman, Rob; Warner, Mark; Kyl, John
567 Pryor, Mark; Inhofe, Jim
324 Reid, Harry
234 Corker, Bob
765 Brown, Sherrod; Schumer, Chuck; Reid, Harry

to this...

Frequency Name
2 Pryor, Mark
1 Bingaman, Jeff
2 Portman, Rob
1 Warner, Mark
1 Kyl, John
1 Inhofe, Jim
2 Reid Harry
1 Corker, Bob
1 Brown, Sherrod
1 Schumer, Chuck

(formating is weird, but the numbers in each of the 2 examples are contained in a separate column)

Thanks!