Splitting of column values

Question

hi everyone,

 

i am having the below input table  

 

INPUT

Name

Hari;shanker;singh

Hari;shanker

Hari

 

 

need to get the output like below please let me know 

OUTPUT
Name	count
Shanker	2
Hari	3
Singh	1

 

 Thanks in Advance