How to aggregate data from the multiple fields into one new field?

[CBabb]

Hi - I have a field (let's call it Field X) in each Deal and I have multiple Deals related to one Contact.

I want to aggregate the data from the Field Xs and concatenate them into Field Y.

Is this possible? 

[karstenkoehler]

Hi @CBabb,

Yould you specify what exactly the aggregation / concatenation should look like? If you have deals with values "A", "B", and "C", do you want to field on the contact record to say "ABC"?

Best regards

[JHouse5]

I need this same this and yes, so that the result is ABC. I can't figure out how. For example, (Street) + space + (City) + space + comma + (State) + space + (Postal) = Full Address