Pivot combining a field

Hi

I have a pivot table, I have added the description field in and as it can be a combination of one or more alarms it has split the lines. If it is for the same site i needed the description field to contain both. See example below:


How would you combine two results to show one line .

Currently:

Site name Post code Description Total

Line 1 Paddington BX3 3TU Intruder 14
Line 2 PA 1


Should show:

Site name Post code Description Total
Line 1 Paddington BX3 3TU Intruder, PA 15


Hope this makes sense

just looked back at my thread the current pivot looks like this (not sure if the spaces are being removed)


Currently:

Site name Post code Description Total
Paddington BX3 3TU Intruder 14
PA 1