Pivot - Sum and Concatenation

[pisistrato]

Hi all,

I am currently working with a data set like this

UID01 a 10
UID02 a 20
UID03 b 5
UI004 a 30
UI005 c 5
UID06 d 5

What I would like to do is to sum values in column 3 on the basis of the values in column 2 (a,b,c and d).
a 60
b 5
c 5
d 5

This is easy, ok! However, at the same time, I would like to concatenate the values in column 1, still on the basis of the values in column 2,to obtain this

a 60 UID01;UID02;UID04
b 5 UID03
c 5 UID05
d 5 UID06

How can I do this?


Thank you in advance for your help.