SQL - Extract multiple occurrences of string in a column into individual columns

Question

I have a column in a table which has multiple occurrences of a string, need to extract each such occurrence and create a new column with the value.

for example : Column A has multiple values for name , need to create new column for each value of name.

Given :

column A

name: Jake , age : 21 , name : Taylor , age : 20 , name : Glen , age : 30

Expected Output :

Column A | name 1 | name 2 | name 3

name:Jake,....,age:30 | Jake | Taylor | Glen