Concatenate string values from multiple rows of same column into a one cell

Question

Hello! I am trying to modify my data set to concatenate values from a column of data into one cell, so rather than multiple rows of data, it can be condensed into one row. See attached screenshot of the starting data set and what the goal output would be. Thank you!

Alteryx Community Question.PNG

aatalai · Accepted Answer

use the summarise tool group by the first couple of columns and then concanteate (using the summarising tool)