To combine multiple columns based on other columns data

[tapanrastogi]

Hello, Here's the input file 

col1	col2
abc	cat
abc	bat
abc	chat
hjd	pat
hjd	rat
hjd	code
mno	stole
mno	123
mno	roll

The output I am expecting as 

col1	col2
abc	cat bat chat
hjd	pat rat code
mno	stole 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

[DataNath]

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

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