concatenate formula need help

[lilyyangadsk]

may i ask how do i use formula to concatenate one opportunity number with different STATUS into STATUS NEEDED as in attachment, thank you very much.

[Qiu · Accepted solution]

@lilyyangadsk 
If you dont insist on using Formula tool we can achive this with Summarize tool easily

[lilyyangadsk · Accepted solution]

thank you very much!

[lilyyangadsk]

May i ask another question, if in status it has same text, how do I make it as one text not duplicate it. same as parter name column, some are same name but some different, how do i delete duplicate same name in one line. thank you

[CoG · Accepted solution]

There is a saying: "Two heads are better than one". In this case, "Two Summarize Tools are better than one".

If you perform your aggregation in 2 steps, this will allow you to:

1. Group by [status] and concatenate [quote]

2. Then concatenate [status] and [quote] to finish the aggregation

Hope this helps and Happy Solving!

[lilyyangadsk]

thank you very much, it works!