[Help] Changing data from row to column

Question

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.

aatalai · Answer

@weslleyroque  this could also help

[Help] Changing data from row to column.yxmd

binu_acs · Answer

@weslleyroque One way of doing this

Transpose_20052024.yxmd

harshendra · Answer

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.