Spreadsheet: 195945d1353739877-consolidatng-rows-of-data-in-to-one-row-based-on-cell-value-pivot_solution
Sheet: Summary

Sum of Total
Cust Ref | Contact executive | Total
1ABP001 | nickyj | 1
1ACC001 | charliew | 1
1ACC012 | nickm | 5
1ACE002 | maryd | 1
1ACE004 | maryd | 1
1ACI001 | maryd | 6
1ADB001 | stuartm | 0
1ADC001 | nickm | 1
1ADV002 | jacquim | 1
1AEC001 | alisonm | 1
1AER001 | charliew | 0
1AGA002 | nickm | 26
1AHD001 | nickm | 3
1ALC001 | nickyj | 2
1ALP001 | charliew | 3
1ALP003 | charliew | 6
1ALT001 | stuartm | 0
1AMC003 | jacquim | 1
1AME001 | nickyj | 0
1AMW001 | jacquim | 2
1APO002 | zoer | 0
1ARC002 | nickm | 3
1ARC003 | zoer | 7
1ARC004 | nickm | 0
1ART003 | charliew | 6
1ATL007 | nickm | 1
1AUT011 | zoer | 1
1AUT055 | lindal | 1
1AVX001 | zoer | 1
1BAK004 | zoer | 1
1BAL002 | maryd | 1
1BAR012 | maryd | 7
1BEA001 | nickyj | 4
1BEC001 | maryd | 0
1BEI001 | nickm | 7
1BEI002 | nickm | 1
1BEL006 | charliew | 2
1BER001 | nickyj | 1
1BEW002 | zoer | 0
1BIG003 | nickm | 0
1BIL001 | maryd | 3
1BLA006 | zoer | 0
1BLA007 | stuartm | 1
1BLA008 | stuartm | 1
1BOH001 | nickm | 2
1BOY001 | stuartm | 1
1BRA004 | maryd | 17
1BRA006 | zoer | 16
1BRA007 | maryd | 11
1BRA009 | maryd | 1
1BRE002 | nickm | 0
1BRI015 | charliew | 10
1BRI025 | nickm | 1
1BRI030 | nickm | 0
1BRO001 | lindal | 1
1BRU002 | stuartm | 1
1BSN002 | zoer | 3
1BUL001 | maryd | 0
1CAL002 | zoer | 0
1CAL006 | nickm | 0
1CAM002 | zoer | 3
1CAM005 | nickm | 1
1CAM008 | jacquim | 3
1CAP015 | [NAME] | 1
1CAR004 | charliew | 2
1CAR020 | maryd | 19
1CAR021 | stuartm | 1
1CAS014 | stuartm | 1
1CFS001 | zoer | 1
1CHA010 | nickm | 1
1CHA015 | stuartm | 0
1CHE008 | charliew | 1
1CHE010 | nickm | 1
1CHI004 | stuartm | 4
1CHK001 | zoer | 1
1CIT020 | nickm | 1
1CLA024 | stuartm | 0
1CLO001 | jacquim | 8
1CLY001 | stuartm | 1
1COC001 | stuartm | 1
1COH001 | charliew | 1
1COM006 | nickm | 4
1CON020 | charliew | 1
1COO005 | jacquim | 2
1COO006 | stuartm | 1
1COR008 | maryd | 10
1COR035 | nickm | 12
1COT002 | jacquim | 2
1COT004 | central | 0
1CUL002 | stuartm | 1
1CVS001 | nickm | 6
1DAI001 | nickyj | 0
1DAN005 | nickm | 0
1DAN020 | maryd | 1
1DAR003 | zoer | 3
1DAR004 | maryd | 6
1DDD001 | nickyj | 11
1DEA001 | zoer | 23
1DEL001 | charliew | 1
1DEM001 | zoer | 4
1DEN002 | charliew | 1
1DEP001 | stuartm | 2
1DES001 | charliew | 4
1DEW004 | nickyj | 3
1DEX001 | jacquim | 3
1DOM001 | charliew | 22
1DOW001 | lindal | 1
1DRS004 | maryd | 1
1DSG509 | charliew | 1
1DSG513 | charliew | 1
1DSG519 | charliew | 33
1DSG520 | charliew | 1
1DUR003 | charliew | 1
1DWB001 | stuartm | 1
1DYN003 | stuartm | 1
1EAS005 | maryd | 3
1EAS008 | maryd | 1
1EBV001 | charliew | 0
1EHS001 | nickm | 5
1ELI002 | stuartm | 1
1ELL001 | zoer | 4
1EMM001 | stuartm | 1
1ENI001 | zoer | 0
1ENT001 | charliew | 1
1ENT006 | nickm | 1
1ESS002 | nickm | 0
1EUR002 | nickm | 0
1EXO001 | stuartm | 1
1FAA002 | andyr | 14
1FAU001 | nickm | 3
1FFP001 | charliew | 4
1FIE010 | nickm | 0
1FJC002 | zoer | 1
1FLE006 | nickm | 1
1FOG001 | stuartm | 1
1FOR008 | maryd | 2
1FOX001 | stuartm | 1
1FRA003 | nickm | 4
1FRO001 | charliew | 2
1FSI001 | stuartm | 1
1FUL001 | maryd | 15
1FUT002 | stuartm | 1
1GAL009 | nickm | 8
1GAL010 | nickm | 2
1GAR007 | stuartm | 1
1GAT002 | maryd | 3
1GEL001 | stuartm | 3
1GEO002 | nickm | 3
1GEO003 | nickm | 1
1GEO008 | maryd | 1
1GEP001 | lindal | 1
1GET004 | maryd | 1
1GIL004 | stuartm | 1
1GLE003 | jacquim | 1
1GRO003 | maryd | 0
1HAD002 | stuartm | 3
1HAL007 | maryd | 38
1HAL008 | nickm | 4
1HAM002 | nickm | 7
1HAR001 | zoer | 5
1HAR007 | nickm | 0
1HAR016 | rachaele | 1
1HAY001 | maryd | 1
1HAY002 | zoer | 2
1HEL003 | stuartm | 1
1HER006 | lindal | 1
1HEV002 | stuartm | 1
1HIG003 | jacquim | 0
1HIG004 | stuartm | 1
1HIL001 | charliew | 3
1HIT002 | charliew | 3
1HLL001 | stuartm | 0
1HOD002 | maryd | 3
1HOD006 | maryd | 2
1HOD007 | maryd | 1
1HOL001 | billyg | 3
1HOM002 | maryd | 117
1HOO001 | nickyj | 1
1HOS005 | stuartm | 2
1HOU001 | maryd | 2
1HSF001 | lindal | 4
1HYL001 | stuartm | 10
1ICT001 | stuartm | 1
1IFI001 | nickyj | 3
1IGT001 | nickm | 7
1IGU001 | nickyj | 0
1INC003 | stuartm | 0
1INC004 | maryd | 6
1INS004 | nickyj | 1
1INS005 | nickm | 7
1INT005 | charliew | 2
1INT014 | stuartm | 1
1INT020 | [NAME] | 1
1JAM012 | stuartm | 1
1JAM014 | stuartm | 2
1KET004 | zoer | 4
1KET005 | stuartm | 1
1KIS001 | stuartm | 0
1KNA001 | lindal | 1
1KNI007 | charliew | 1
1KNO001 | stuartm | 1
1KOY001 | zoer | 0
1KRO002 | charliew | 8
1KRO005 | lindal | 3
1KTM001 | lindal | 1
1KWI003 | nickm | 130
1LAN005 | stuartm | 1
1LAS002 | stuartm | 2
1LAT001 | nickyj | 1
1LEY001 | stuartm | 1
1LOW001 | charliew | 1
1LUM001 | charliew | 0
1LUN001 | nickyj | 3
1MAP002 | zoer | 2
1MAR013 | maryd | 37
1MAR025 | stuartm | 0
1MAR028 | charliew | 7
1MAS002 | jacquim | 60
1MAT001 | charliew | 6
1MAT006 | stuartm | 3
1MAX001 | charliew | 1
1MAX002 | nickm | 7
1MCQ001 | jacquim | 1
1MEA001 | jacquim | 9
1MEA002 | jacquim | 1
1MED001 | nickm | 1
1MED002 | charliew | 2
1MEN001 | [NAME] | 0
1MER003 | nickyj | 1
1MER015 | stuartm | 1
1MET004 | stuartm | 1
1MIC007 | stuartm | 3
1MID005 | charliew | 0
1MID014 | stuartm | 1
1MIR001 | nickm | 7
1MIT015 | maryd | 9
1MOL001 | nickyj | 11
1MON003 | zoer | 1
1MOO002 | maryd | 0
1MOO003 | maryd | 3
1MOO004 | maryd | 3
1MOO010 | lindal | 1
1MOR006 | charliew | 1
1MOR007 | charliew | 0
1MOR008 | gilesb | 4
1MSI001 | zoer | 1
1MSS001 | nickm | 15
1MUI001 | nickyj | 3
1NAI001 | stuartm | 1
1NAT015 | nickm | 0
1NBT001 | charliew | 38
1NEI005 | maryd | 0
1NEN001 | zoer | 2
1NES001 | kcc | 1
1NET002 | charliew | 1
1NEW002 | nickyj | 2
1NEW010 | maryd | 3
1NEW011 | maryd | 0
1NEW012 | maryd | 0
1NEX002 | stuartm | 1
1NIC004 | andyr | 15
1NIC007 | zoer | 3
1NIG002 | zoer | 2
1NMC001 | nickyj | 3
1NOR015 | maryd | 26
1NOR018 | stuartm | 1
1NOR080 | stuartm | 1
1NOR081 | nickm | 1
1NOT020 | maryd | 297
1NUC001 | zoer | 0
1OEM002 | nickyj | 2
1OFF001 | nickm | 2
1OFF002 | stuartm | 0
1OME001 | nickm | 23
1ONE005 | stuartm | 1
1ONE006 | stuartm | 1
1OPT004 | alisonm | 2
1ORA001 | stuartm | 1
1ORI002 | nickm | 4
1ORR001 | stuartm | 1
1OUT001 | stuartm | 0
1PAC002 | zoer | 0
1PAN001 | nickyj | 13
1PAP002 | stuartm | 1
1PAR003 | charliew | 1
1PAR024 | nickyj | 32
1PAX001 | charliew | 1
1PEN006 | charliew | 1
1PET002 | zoer | 4
1PHA001 | nickyj | 3
1PIE001 | nickm | 2
1POF001 | [NAME] | 0
1POL001 | jacquim | 1
1POL007 | nickm | 1
1POU001 | nickm | 17
1POW004 | stuartm | 0
1PPG001 | nickm | 6
1PPG005 | nickm | 3
1PRE008 | zoer | 1
1PRE009 | lindal | 2
1PRE012 | stuartm | 1
1PRI002 | charliew | 1
1PRO004 | zoer | 1
1PRO006 | zoer | 0
1PRO030 | stuartm | 2
1PRO031 | nickm | 2
1PSY001 | maryd | 0
1PUB002 | zoer | 1
1PUR006 | nickm | 3
1PYG001 | stuartm | 0
1PYR001 | nickm | 1
1RAC010 | nickyj | 1
1RAL001 | maryd | 2
1RAN003 | charliew | 2
1RAP003 | nickm | 1
1REA002 | zoer | 1
1RET002 | nickm | 1
1REV001 | charliew | 2
1RID006 | nickm | 1
1RIV001 | maryd | 18
1ROB005 | stuartm | 2
1RON001 | nickm | 20
1ROW008 | stuartm | 1
1RUF001 | nickm | 1
1SAF002 | jacquim | 6
1SAM002 | charliew | 5
1SAN008 | nickm | 3
1SAN014 | nickm | 1
1SCH003 | nickyj | 1
1SCH005 | nickyj | 7
1SCO001 | maryd | 1
1SCO004 | charliew | 0
1SDA002 | andyr | 3
1SDA005 | andyr | 1
1SEA002 | charliew | 2
1SEA003 | stuartm | 1
1SEC005 | zoer | 1
1SEL001 | charliew | 3
1SEL003 | charliew | 2
1SHA001 | gilesb | 2
1SHA005 | maryd | 0
1SHA008 | nickm | 13
1SIG002 | maryd | 14
1SIM001 | zoer | 4
1SIN001 | nickyj | 0
1SIN003 | stuartm | 1
1SIP001 | zoer | 2
1SMC001 | nickm | 6
1SME002 | maryd | 1
1SOL003 | maryd | 10
1SOM004 | maryd | 2
1SOU020 | nickm | 1
1SOV010 | charliew | 1
1SPA003 | stuartm | 1
1STA012 | nickm | 5
1STE002 | maryd | 1
1STE010 | stuartm | 0
1STO003 | stuartm | 1
1SUP003 | charliew | 1
1SUT002 | charliew | 2
1SWA001 | nickm | 7
1SWI001 | charliew | 1
1SWI002 | charliew | 3
1SYN003 | nickm | 0
1TEC001 | nickyj | 31
1TET001 | nickm | 8
1TEX001 | jacquim | 7
1THA004 | stuartm | 0
1THE020 | maryd | 0
1THE027 | charliew | 3
1THE030 | stuartm | 0
1THO003 | charliew | 1
1THO010 | nickm | 0
1THY001 | nickm | 20
1TIM002 | nickyj | 10
1TIT001 | stuartm | 1
1TNT001 | maryd | 5
1TOP001 | stuartm | 0
1TOT001 | nickm | 4
1TOT004 | maryd | 1
1TRA006 | stuartm | 1
1TRE001 | nickyj | 3
1TRI001 | nickm | 3
1TRU002 | zoer | 11
1TRU005 | maryd | 0
1TUB001 | nickm | 123
1TWO001 | maryd | 0
1UKM001 | zoer | 10
1ULT003 | nickm | 0
1UNI020 | stuartm | 0
1UTP001 | zoer | 0
1VAI001 | charliew | 0
1VET001 | lindal | 0
1VIL001 | nickyj | 5
1VIS003 | stuartm | 3
1VIT001 | alisonm | 0
1VOI001 | stuartm | 1
1WAT002 | jacquim | 2
1WAT004 | stuartm | 1
1WEA008 | zoer | 1
1WEA009 | zoer | 3
1WEL010 | nickm | 2
1WES010 | zoer | 1
1WHO002 | lindal | 1
1WIL010 | nickm | 25
1WOR001 | nickm | 1
1WOR002 | stuartm | 1
1WRE002 | maryd | 3
1WYE001 | charliew | 2
1YAR003 | maryd | 1
1ZOD001 | andyr | 1
Grand Total |  | 2095