Combining text data in multiple rows into one cell

[RyanDhaliwal]

Hi all,

I currently have a data set where there is data related to a row however is spread out in multiple cells in a column (below). Is there a way of consolidating the text data into 1 cell. I.e. the picture below applied to lots of data 

[geraldo]

@RyanDhaliwal

use the summarize tool and select all fields and add group by and this column you want to consolidate use concatenate