Please Help!!!!
My need is to sort, combine similar values of rows in column 1 (having 1
value in cell at the end), then combine refdes in column 2, separated by a
comma, (ex C4,C8), then adding quanities (scroll down to see desired end
result)

PartType RefDes PartDecal QTY
CAP_330PF_0805 C3 805 1
CAP_470PF_0805 C4 805 1
CAP_470PF_0805 C8 805 1
CAP_470PF_0805 C9 805 1
CAP_330PF_0805 C11 805 1

PartType RefDes PartDecal QTY
CAP_330PF_0805 C3,C11 805 2
CAP_470PF_0805 C4,C8,C9 805 3


Thanks sooo much for your help!