Parse String to List

Hi,

 

I have a column in database with data as string as following format. 

 

 

 

 

Requirement 1 : List each value in

as

• Primary
• Lower Secondary 
• Secondary
• Higher Secondary
• ........................
• ........................
• Ph.D 

  

Generate Chart showing based on occurance of Value (Vales in each row wil be same as in figure but the no of values may differ in each row)

 

S.No	Type	No of Occurances
1	Primary	23
2	Lower Secondary	12
3	Secondary	55

 

Please help me to sort this out. Thanks in advance.