[Help] Changing data from row to column

[weslleyroque]

Hey -  I was hoping someone could help with below query.

I've got a massive data file containing names and numbers, however I would like to separate the numbers and put each in individual cell as per below example. 

Not sure if this is possible, I've been trying to do for quite some time but I'm still learning.. If anyone can assist would be great.

 Data:

How I would like it to be. 

[harshendra]

First use the Text To Columns tool to parse the second column into multiple columns. Then use Transform to get the data in format you shared. please share tables/excel if you want to see this as a workflow.

[binuacs]

@weslleyroque One way of doing this

[aatalai]

@weslleyroque  this could also help