Utilizing Text to Columns over Multiple Columns

[yuganda]

I have an excel file with 60 columns that has data in the second row, that I want to break up into additional rows if there is a "," (multiple columns have ","). I used the text to columns function, on Column 2, but it caused column 1,  3, 4, 5, 6, 7, and 8 to repeat the same row information over and over and it seems I would have to use the Text to Column function for each column that has a "'," in it.  Is there an easy way in alteryx to go from the below input to the desired output?

Input

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
523	745,745,76876	745	9768,546	6734	769	1231	6436,5346

Desired Output:

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
523	745	745	9768	6734	769	1231	6436
	745		546				5346
	76876

[Aaron_Harter · Accepted solution]

@yuganda, 

You may want to Transpose the data, perform the parse with Text to Columns, then Cross Tab back into your original field schema:

[yuganda]

Thanks, the above worked, never thought to used the tile function.