Keep text Column in same cell

[Puyi05]

I am trying to read the following into Alteryx:

The goal is to have all the text in the location column concatenate to the same cell for each name. I also added a column called Para? which adds Paragraph to each line that needs to be concatenated with the the line that contains name. I tried different ways like summarize, formulas but can't find the solution.

Goal:

[IraWatt · Accepted solution]

Hey @Puyi05,

You can use the summarize tools concatenate function:

Any questions or issues please ask :)
HTH!
Ira

[Ben_H · Accepted solution]

Hi @Puyi05,

You need to insert an ID field to so that your concatenated fields can be grouped correctly.

@IraWattgot there before me with a slightly different methodology.

[binu_acs]

@Puyi05 one way of dong this

[Puyi05]

Thank you all for the responses! All solutions worked perfectly.