How to split cell and keep relationship with other column

Question

Hello,

I have a dataset that looks like this

Point AEntry1,Entry2,Entry3Point BEntry1,Entry2,Entry3Point CEntry1,Entry2,Entry3

And I want to change it to something like this

PointAEntry1 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

IraWatt · Accepted Answer

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