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
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.