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