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

[melissa_grit]

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!

[aatalai · Accepted solution]

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

[AmitMiller]

Hi @melissa_grit , thank you for your question!

As Aatalai mentioned, the summarize tool is your friend here.

Using this dataset as the input: 

(Notice I used 2 different "groups" of values)

This is what the Summarize tool will produce:

Do note - you can shift-select all the columns, then ctrl-select the relevant column you want to concatenate - to quickly choose all the other columns (as opposed to selecting the columns one by one).

See workflow attached.

Hope that helps!