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

[shaheer]

I want to format the following names:

Name1	Name2	Name3	Name4
John, Joe	Rock, Chris	Rock, The	Wayne, Bruce

Like so:

Name1	Name2	Name3	Name4
Joe John	Chris Rock	The Rock	Bruce 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.

[michelle_mathews]

@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 

[binuacs]

@shaheer One way of doing this

[Emmanuel_G]

@shaheer 

One way of doing that easily.