Aggregate for similar data entry and count it

[Riccardo]

Hello,

I have this data set "data - as is". My goal is to arrive to "data -to be". Please see the image below.

I have to use loop into script or I can use logic into field expression?

Can you help me, please?

Thanks

[GaryGiles]

You can use a series of concat functions:

=concat(nome,'/')&' ('&concat(number,'/')&' '&concat(email,'/')&')'

You could also use the Only fuction for number and email if there is always one value associated, but concat will produce the same result for 1 value and accomodate multiple values.

Hope that helps.