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