Keep text Column in same cell

Question

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:

Alteryx_test.xlsx

IraWatt · Accepted Answer

Hey @Puyi05,

You can use the summarize tools concatenate function:

Any questions or issues please ask :)
HTH!
Ira

Ben_H · Accepted Answer

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.