How to split cell and keep relationship with other column

[MWon]

Hello,

I have a dataset that looks like this 

Point A	Entry1,Entry2,Entry3
Point B	Entry1,Entry2,Entry3
Point C	Entry1,Entry2,Entry3

And I want to change it to something like this

PointA	Entry1
	Entry2
	Entry3
....	....

To that end, how would I accomplish this? I would imagine I have to use the text to column tool, but I want to preserve the relationship between the first column and the split one

[DataNath]

@MWon  If you use the Text to Column tool with 'Split to Rows' enabled, you'll still maintain the relationship as the Point field will still be next to the related entry even when split:

Can add in the gaps with a couple of Formula tools:

[IraWatt · Accepted solution]

Hey @MWon,

That is how I would do it, Text to columns set to split to rows

If you want the Spaces I would just use a sample tool:

Any questions or issues please ask :)
HTH!
Ira