Distinct Values

I am trying to use distinct values for the below requirement it is not working, Can any of you throw in some suggestion,

The original data from the sql is

Pallet#   PO#        Part#      Cust.Part#     Box   GrossWeight
----------------------------------------------------------------
1         PO1        B1234      1234           5        146.67
1         PO2        B1235      1235           6        200.00
1         PO3        B1236      1236           7        200.00
2         PO1        B1234      1234           5        300.86
2         PO2        B1235      1235           6        300.00

Output should be:

Pallet#   PO#             Part#      Cust.Part#     Box   GrossWeight
-----------------------------------------------------------------------
1         PO1,PO2,PO3     B1234      1234           5        546.67
                                     B1235      1235           6
                                     B1236      1236           7
2         PO1,PO2           B1234      1234           5        600.86
                                    B1235      1235           6