How to Apply Text to Columns for Multiple Columns to Rearrange Text?

Question

I want to format the following names:

Name1Name2Name3Name4John, JoeRock, ChrisRock, TheWayne, Bruce

Like so:

Name1Name2Name3Name4Joe JohnChris RockThe RockBruce Wayne

The attached image of the workflow helps me rearrange names in one column, but how can I go about doing the exact same thing for each column efficiently?

Thanks.

Capture.PNG

Emmanuel_G · Answer

@shaheer

One way of doing that easily.

How to Apply Text to Columns for Multiple Columns to Rearrange Text.yxmd

binu_acs · Answer

@shaheer One way of doing this

Text_Column_1001.yxmd

michelle_mathews · Answer

@shaheer , you could use the Transpose tool to get all the names in one column, apply your formula once, and then use the Crosstab tool to unpivot them back into headers

Attaching an example like this, as well as one using Regex

ParsingName.yxmd