To combine multiple columns based on other columns data

Question

Hello, Here's the input file

col1col2abccatabcbatabcchathjdpathjdrathjdcodemnostolemno123mnoroll

The output I am expecting as

col1col2abccat
bat
chathjdpat
rat
codemnostole
123
roll

With my approach, I am getting the output separated by commas but not in next line as shown.

I would appreciate the help

alteryx.xlsx

DataNath · Answer

Have just replied to this in your other thread: https://community.alteryx.com/t5/General-Discussions/Combining-columns-by-another-columns-data-in-excel/td-p/938881

You'll need to use 
 as the separator in your summarise tool, rather than a comma.