Transpose data into 1 cell

[Jenina]

Hi all, happy 4th!

I wanted to transpose my series of data into 1 cell only in excel, and to put comma in between. Can't figure out how to do this. Appreciate the help. Thanks!

After:

[Raj]

@Jenina 
use summarize tool to concatenate all the values

[Raj · Accepted solution]

@Jenina 
find workflow attached
mark done if solved.

[Jenina]

@Raj  This works, thank you!