Spreadsheet: 84130d1284123325-count-specific-values-in-a-pivot-table-example-pivot-table1
Sheet: Raw Data

WORK ORDER # | AREA | DATE | SERVICE CODES 1 | SERVICE CODES 2 | SERVICE CODES 3 | SERVICE CODES 4 | SERVICE CODES 5 | SERVICE CODES 6 | SERVICE CODES 7 | SERVICE CODES 8 | SERVICE CODES 9 | SERVICE CODES 10 | SERVICE CODES 11 | SERVICE CODES 12
24012403200006012 | Q1 | 09/10/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24012740100000053 | Q1 | 09/13/2010 PM | (S | ;= | -6 | /( | /A | AA | E/ | }~ | }}
24017465300032005 | Q1 | 09/10/2010 PM | (5 | /A | ?? | AA | CG | [NAME] | E/ | }{ | }} | }T | NX | XW
24018620600001004 | Q1 | 09/11/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | #9 | AA | C5
24018779900004001 | S3 | 09/10/2010 AM | .} | .V | .Z | (S
24065222400017001 | Q2 | 09/10/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24065406010095006 | Q1 | 09/11/2010 AM | .} | (5 | ;= | /A | ?= | {! | AA
24066254905022002 | Q1 | 09/13/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | #9 | AA | CG
24066416100017004 | Q1 | 09/10/2010 PM | .} | (S | (5 | ;= | /( | /A | ?? | AA | CG | DS | E/ | I}
24079000020590016 | Q1 | 09/10/2010 AM | .! | .Z | <: | (S | ;K | -6 | /A | ?= | #9 | AA | E/ | }~
24090307700008025 | Q1 | 09/15/2010 AM | (5 | ;= | ?= | #$ | {! | AA | CG | C5 | D. | }~ | }} | }T
24015203105051001 | Q1 | 09/17/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?= | #9 | AA | C5
24015431200021001 | S3 | 09/10/2010 AM | .! | .Z | (S | ;= | ;K | -6 | /A | ?? | ?= | ?= | #9 | AA
24016402400012001 | Q2 | 09/15/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | #9 | AA | DS | E/
24016481800033001 | Q1 | 09/16/2010 AM | .! | .Z | (S | ;= | ;K | -6 | /( | /A | ?? | ?= | ?= | #9
24017381600002015 | Q1 | 09/11/2010 PM | (5 | ;$ | /W | AA | C<
24018360500007001 | Q1 | 09/10/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | #9 | AA | CG | C5
24064208500007022 | Q1 | 09/10/2010 AM | <: | !! | ;= | ?= | #$ | {! | AA | CG | [NAME] | HO | }T | L$
24064210000004001 | Q1 | 09/17/2010 PM | .! | .} | .Z | <: | (S | ;= | ;K | /( | /A | ?? | ?= | #9
24066088600005034 | Q1 | 09/10/2010 AM | .! | <: | (5 | ;= | ;K | -U | -6 | ?= | ?= | #9 | {! | AA
24066474600007012 | S3 | 09/10/2010 PM | .! | (5 | ;K | -6 | ?= | ?= | #9 | {! | AA | CG | C5 | EK
24066496300008051 | Q2 | 09/10/2010 PM | (5 | -L | -U | #( | ~9 | AA | CG | }} | }T | KJ | OR | T0
24090351700011008 | Q1 | 09/13/2010 PM | .Z | (S | ;K | /( | /A | ?= | AA | CG | D- | DS | E/ | }~
24101390800082010 | Q1 | 09/10/2010 PM | D0 | D2 | /A | ?? | AA | CG | E/ | }{ | }} | }T | NX | XW
24101443100001007 | Q1 | 09/11/2010 PM | .! | (5 | ;K | -6 | /( | /A | ?? | ?= | #9 | {! | AA | CG
24121000031407001 | Q1 | 09/10/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | #9 | AA | C5 | DS
24121358000004012 | Q1 | 09/10/2010 PM | .} | (S | (5 | !K | !K | /A | ?? | {! | AA | CG | DS | E/
24121444500009007 | Q1 | 09/11/2010 AM | ;= | -6 | /( | /A | ?? | :6 | #~ | {! | AA | CG | I6 | }{
24121590100000001 | Q1 | 09/13/2010 PM | .! | .Z | (S | ;K | -6 | /A | ?? | ?= | #9 | AA | CG | D<
24121613100003004 | Q1 | 09/10/2010 PM | (5 | -6 | /( | /A | ?= | {! | AA | CG | C5 | DS | E/ | }~
24127603600019001 | Q1 | 09/10/2010 AM | .! | .} | .Z | (S | ;K | /A | ?? | ?= | ?= | #9 | AA | C5
24153803400000006 | Q1 | 09/15/2010 AM | *$ | ;= | -K | -6 | /A | ?? | #7 | AA | E/ | I2 | I6 | }{
24184371000047014 | Q1 | 09/17/2010 AM | .} | (S | $= | AC | PZ | D0 | D2 | /( | /A | ?? | AA | CG
24012171900027001 | Q1 | 09/10/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24012361400010001 | Q1 | 09/15/2010 PM | .Z | (S | ;K | /A | ?? | ?= | ?= | AA | CG | D- | E/ | }{
24012652200004003 | Q1 | 09/16/2010 AM | (S | (5 | ;$ | -6 | /A | AA | DS | E/ | }~ | }} | OR | P2
24012677800028002 | Q1 | 09/11/2010 PM | .! | (S | (5 | ;K | -6 | /( | /A | ?? | ?= | #9 | {! | AA
24012852800009005 | Q1 | 09/10/2010 PM | .} | $= | AC | PZ | D0 | D2 | ;= | AA | CG | DS | IL | }~
24014173700009001 | Q1 | 09/10/2010 AM | .! | .Z | (S | ;= | ;K | -6 | /A | ?= | #9 | AA | C5 | DS
24015000011098017 | Q1 | 09/17/2010 PM | .Z | ;K | /A | ?= | AA | CG | D- | }~ | }T | L? | PZ | XD
24017122800002001 | Q1 | 09/10/2010 AM | .! | .} | .Z | <: | (S | ;= | ;K | /A | ?? | ?= | #9 | AA
24018747200016001 | Q1 | 09/11/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | ?= | #9 | AA | CG
24019202800019001 | Q1 | 09/11/2010 AM | .! | .} | .Z | (S | ;K | /( | /A | ?= | #9 | AA | CG | C5
24019263400014050 | Q1 | 09/13/2010 PM | <: | (5 | !A | ;= | ?= | ?= | #( | {! | AA | CG | C5 | DM
24019442500015001 | Q1 | 09/13/2010 AM | .! | .Z | (S | ;= | ;K | -6 | /( | /A | ?? | ?= | #9 | AA
24019641100039005 | Q1 | 09/11/2010 AM | (5 | ;= | /A | ?? | ?= | :? | {! | AA | D/ | }{ | }} | L$
24064141700003015 | Q1 | 09/13/2010 PM | (5 | ;= | -6 | ?= | ?= | {! | AA | CG | [NAME] | C5 | D. | D~
24064163600024001 | Q1 | 09/11/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24065000000013029 | Q1 | 09/14/2010 PM | (5 | ;= | -6 | ?= | ?= | {! | AA | AF | CG | C5 | E6 | IB
24066478100012013 | Q1 | 09/12/2010 PM | -6 | ?= | {! | AA | AE | KJ | OV | P2 | Y: | ZH | 1K | 2H
24070251200007033 | Q1 | 09/14/2010 AM | .! | (5 | ;= | ;K | -6 | ?= | #9 | {! | AA | CG | C5 | DG
24072314805012024 | Q1 | 09/11/2010 PM | (5 | ;= | ?= | {! | AA | CG | D/ | }T | L$ | L? | P2 | S{
24073320405052007 | Q1 | 09/11/2010 PM | .Z | ;K | ?= | AA | CG | D- | }T | PZ | XD | ZH | Z8 | 1{
24090000020944014 | Q1 | 09/11/2010 AM | ;= | -6 | ?= | {! | AA | AF | CG | C5 | }T | KJ | L$ | L?
24090386705035001 | Q1 | 09/11/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | #9 | AA | C5
24095000021933001 | Q1 | 09/12/2010 AM | .! | .Z | (S | ;K | -6 | /( | /A | ?? | ?= | #9 | AA | E/
24101541000004016 | Q1 | 09/12/2010 PM | .! | (5 | !# | ;= | ;K | ?= | ?= | #9 | {! | AA | C5 | DM
24104000015802017 | Q1 | 09/11/2010 PM | (5 | ?= | ?= | {! | AA | CG | D/ | }} | }T | L$ | L? | P2
24104336000072001 | Q1 | 09/12/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | #9 | AA | E/ | }~
24121263100006002 | Q1 | 09/13/2010 AM | .! | .Z | (S | ;K | -6 | /A | ?= | #9 | AA | C5 | D. | E/
24121479200004013 | Q1 | 09/11/2010 AM | .} | (5 | ;$ | ?? | AA | HO | IF | }{ | KJ | P2 | ZH | 1V
24127000041957003 | Q1 | 09/11/2010 AM | .! | <: | (5 | !# | ;K | /A | ?= | #9 | {! | AA | }~ | }}
24127000042492001 | Q1 | 09/11/2010 PM | .! | .} | .Z | (S | ;K | /A | ?? | ?= | #9 | AA | CG | E/
24127784600002001 | Q1 | 09/10/2010 PM | .Z | (S | ;K | /A | ?? | ?= | AA
24127790800000011 | Q1 | 09/13/2010 AM | .! | .} | .Z | <: | (S | ;K | /A | ?? | ?= | #9 | AA | E/
24153214000019027 | Q1 | 09/12/2010 AM | <: | (5 | ?= | #$ | #~ | {! | AA | CG | DM | }~ | }} | }T
24153251800008001 | Q1 | 09/13/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | ?= | ?=
24153403700031001 | Q1 | 09/11/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24153584300049001 | Q1 | 09/12/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | #9 | AA | C5 | DS
24153598800000012 | Q1 | 09/10/2010 PM | !# | ;$ | ;= | /A | AA | }~ | OR | P2 | Y: | ZH | 1A | 1K
24153910000016002 | Q1 | 09/11/2010 AM | .} | (S | $= | AB | PZ | ;= | /( | /A | ?? | AA | E/ | }{
24175380100026001 | Q1 | 09/13/2010 AM | .! | .Z | (S | ;K | -6 | /A | ?= | ?= | #9 | AA | CG | C5
24175541905040018 | Q1 | 09/10/2010 PM | (5 | ;$ | ;= | #( | AA | CG | HO | }{ | }} | }T | P2 | Y:
24175610100002001 | Q1 | 09/13/2010 AM | .! | .} | .Z | ;= | ;K | ?= | #9 | AA | C5 | D~ | DS | IL
24179000022479010 | Q1 | 09/10/2010 PM | (5 | /A | #$ | AA | CG | }~
24184454400007001 | Q1 | 09/13/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24523389500029002 | Q1 | 09/10/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?= | #9 | AA | CG
15904176400006029 | S3 | 09/11/2010 PM | .} | .Z | ;K | /A | ?= | ?A | AA | D- | E/ | HO | }~ | }}
23923413300001008 | Q2 | 09/10/2010 AM | .Z | (S | ;K | /A | ?= | ?= | AA | CG | D- | E/ | EH | }~
23923424200000017 | Q2 | 09/10/2010 PM | .Z | (S | ;K | /A | ?= | AA | CG | D- | E/ | EH | }~ | }}
23937283300008001 | Q2 | 09/11/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | #9 | AA | DS
23947357400030001 | Q2 | 09/13/2010 PM | .! | .Z | (S | ;K | -6 | /A | ?= | ?= | ?= | :? | #9 | AA
23947451500008001 | Q2 | 09/10/2010 PM | .! | .Z | (S | ;K | -6 | /A | ?= | ?= | #9 | AA | CG | E/
23963635900022004 | S3 | 09/10/2010 AM | (5 | ;$ | -6 | /A | AA | }~ | }} | OR | P2 | Y: | ZH | 1A
24019303610028030 | Q1 | 09/15/2010 AM | .! | (5 | ;= | ;K | -6 | ?= | #9 | {! | AA | CG | C5 | DM
24019862600006027 | Q1 | 09/17/2010 AM | .! | (5 | ;= | ;K | -U | -6 | ?= | #9 | {! | AA | CG
24054365300002008 | [NAME] | 09/10/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | ?= | #9 | AA
24065426500042012 | Q1 | 09/15/2010 PM | .Z | ;K | /A | ?= | AA | CG | [NAME] | D- | E/
24066550300019001 | Q1 | 09/16/2010 AM | (V | (4 | !* | !F | !X | ;K | -! | /6 | ?= | #6 | AA | D~
24085311600004007 | QZ | 09/11/2010 PM | (5 | ;$ | ;= | /A | ?? | AA | CG | }{ | }} | }T | P2
24085318700005014 | QZ | 09/10/2010 PM | .Z | (S | ;= | ;K | /A | ?= | AA
24089347000015001 | [NAME] | 09/10/2010 AM | .! | .Z | (S | ;= | ;K | -6 | /A | ?? | ?= | #9 | AA | C5
24101500100001021 | Q1 | 09/17/2010 PM | (5 | AA | CG | }{ | }T | ZH | 0- | 1D | 8( | 8! | $= | AJ
24112792400025003 | [NAME] | 09/10/2010 AM | (5 | ;O | /A | ?? | AA | }{ | }} | ZH | 1A | 1V | 8( | 8!
24112830900010009 | [NAME] | 09/10/2010 AM | .} | (5 | ;K | /A | ?? | AA | CG | [NAME] | D- | E/ | HO | }{
24148425300018011 | [NAME] | 09/10/2010 AM | (5 | ;$ | /A | ?? | AA | }{ | }} | P2 | XO | ZH | 1A | 1V
24416130600026044 | QZ | 09/11/2010 AM | .Z | ;K | /A | ?? | ?= | ?= | AA | CG | [NAME]
24416341600005011 | QZ | 09/13/2010 PM | .! | (5 | ;K | -6 | ?? | ?= | #9 | {! | AA | CG | C5 | }{
24422170700007041 | QZ | 09/10/2010 PM | .! | !D | ;= | ;K | #( | #9 | {! | AA | CG | DM | D1 | HO
24422187200017001 | QZ | 09/10/2010 PM | .Z | (S | ;K | /A | ?= | AA | D- | E/ | }~ | }} | }T | L$
24422310915168001 | QZ | 09/11/2010 PM | .Z | (S | ;K | /( | /A | ?? | ?= | AA | D- | E/ | }{ | }}
24422330000017028 | QZ | 09/10/2010 PM | !. | !A | !A | -/ | -U | AA | CG | E6 | HO | }~ | }T | OR
24426145500012013 | QZ | 09/10/2010 AM | D0 | D3 | /( | /A | ?? | AA | CG | }{ | }T
24426240600006004 | QZ | 09/11/2010 AM | .! | .Z | ;= | ;K | -T | -6 | /A | ?? | ?= | ?= | #9 | AA
24426590505094001 | QZ | 09/11/2010 PM | .! | .Z | (S | ;K | -6 | /A | ?= | ?= | #9 | AA | CG | C5
24426710410027017 | QZ | 09/10/2010 PM | (5 | ;= | -6 | ?= | {! | AA | AF | CG | E6 | }} | }T | J3
24426752905033019 | QZ | 09/13/2010 AM | !! | !! | -U | ?= | {! | {! | AA | AE | D/ | KJ | L$ | P2
24435212600043005 | QZ | 09/11/2010 AM | .! | .} | .Z | ;= | ;K | -T | /( | /A | ?? | ?= | #9 | AA
24450000007582021 | QZ | 09/14/2010 AM | (5 | ;$ | AA | P2 | ZH | 0$ | 1D | 8( | PZ | 1!
24450371500017018 | QZ | 09/11/2010 AM | (5 | ;$ | ;O | ?? | AA | CG | }{ | }} | }T | P2 | ZH | 0$
24450748700001001 | QZ | 09/10/2010 AM | .Z | (S | ;K | /( | /A | ?? | ?= | ?= | AA | D- | E/ | }{
24501000049196011 | S3 | 09/11/2010 AM | (5 | -6 | ?= | {! | AA | CG | }~ | }} | }T | L? | P2 | Q*
24501122900011005 | S3 | 09/11/2010 PM | $= | AB | PZ | /( | /A | ?? | AA | }{ | }} | ZH | 0* | 1V
24501391600011001 | S3 | 09/11/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | #9 | AA | CG
24501398205137022 | S3 | 09/10/2010 PM | .Z | ;K | -6 | ?= | ?= | ?A | {! | AA | D- | KJ | P2 | XD
24502265205234005 | S3 | 09/15/2010 PM | .} | (S | (5 | ;$ | /( | /A | ?? | AA | CG
24502508400014001 | S3 | 09/11/2010 AM | .Z | (S | ;= | ;K | /A | ?? | ?= | AA | D- | DS | E/ | EH
24502680400006004 | S3 | 09/10/2010 PM | (S | (5 | -6 | /A | ?? | AA | DS | E/ | }{ | }} | OR | Y:
24503251900002001 | S3 | 09/10/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24517123100021012 | S3 | 09/10/2010 PM | (5 | ;$ | -/ | ?? | AA | CG | }{ | }}
24517401400010001 | S3 | 09/11/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24521120000002049 | S3 | 09/11/2010 PM | .! | (5 | ;K | -6 | ?= | #9 | ~9 | {! | AA | C- | CG | E6
24521261400029001 | S3 | 09/10/2010 AM | .Z | (S | ;K | /A | ?= | AA | D- | E/ | }~ | }} | L? | Q*
24521272200004050 | S3 | 09/11/2010 PM | (5 | ;= | ?= | {! | AA | CG | D/ | DM | }} | }T | KJ | L$
24521332500013001 | S3 | 09/11/2010 AM | .! | .} | .Z | <: | (S | ;= | ;K | /A | ?= | ?= | #9 | AA
24521354100023006 | S3 | 09/10/2010 AM | .Z | ;= | ;K | /( | ?? | ?= | AA | D- | }{ | }} | PZ | XD
24521360300021080 | S3 | 09/10/2010 PM | (5 | -6 | ?= | {! | AA | CG | C5 | D. | FR | }~ | }T | KJ
24521431300026001 | S3 | 09/10/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24521433100036001 | S3 | 09/10/2010 PM | .! | .} | .Z | (S | ;= | ;K | /A | ?? | ?= | ?= | #9 | AA
24521448800026001 | S3 | 09/11/2010 PM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24521473200019009 | S3 | 09/10/2010 AM | (S | -6 | /A | AA | CG | DS
24522905700006001 | S3 | 09/17/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | ?= | ?= | :? | #9
24522923310051023 | S3 | 09/13/2010 PM | #$ | {! | AA | CG | }T | KJ | ZH | 0$ | 1A | 1K | 1V | 8(
24522928100002011 | S3 | 09/10/2010 AM | (5 | ;$ | ?? | AA | GT | }{ | }} | P2 | ZH | 1{ | 1A | 1V
24522983500005012 | S3 | 09/10/2010 AM | (5 | $6 | #( | {! | AA | CG | HO | }{ | }} | }T | KJ | P2
24528264300007001 | Q2 | 09/10/2010 AM | .! | .Z | (S | ;K | -6 | /( | /A | ?? | ?= | #9 | AA | CG
24528310400009001 | Q2 | 09/15/2010 AM | .! | .} | .Z | (S | ;= | ;K | /( | /A | ?? | ?= | #9 | AA
24528322000011011 | Q2 | 09/10/2010 AM | (5 | ;$ | /A | ?? | #$ | AA | CG | }{ | }} | }T | OR | P2
24538235300002024 | S3 | 09/11/2010 PM | .! | (5 | ;K | ?= | #( | #9 | {! | AA | CG | C5 | D< | }{
24550371200003001 | S3 | 09/12/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | ?= | #9 | AA | CG
24550422900007002 | S3 | 09/10/2010 AM | .! | .} | .Z | (S | ;= | ;K | /A | ?= | ?= | #9 | AA | CG