Spreadsheet: 494051d1482151688-converting-eliminating-blank-cell-in-pivot-sample-19-chg1
Sheet: Data Sheet

Sheet 1
 | ch31
 | MonthYear | [NAME] | %Uncontactable | %Diarized | %Taken Up | %Not Interested | %Disqualified | %Enquiry
 | 2016-11-01 00:00:00 | 632227 | 0.5845637721894194 | 0.1449337026099803 | 0.0970173687615366 | 0.08732148421373968 | 0.04694832710403067 | 0.006018407945247514
 | 2016-12-01 00:00:00 | 195519 | 0.5857793871695334 | 0.1418174192789448 | 0.09341803098420103 | 0.09535646152036376 | 0.05425559664278152 | 0.005805062423600776
 | ch32
 | CallCentre | MonthYear | %Uncontactable
 | Acquisitions | 2016-11-01 00:00:00 | 0.2720063609859528
 | Business Banking | 2016-11-01 00:00:00 | 0.264166724750819
 | Cash Investments | 2016-11-01 00:00:00 | 0.4683827644096251
 | Hunters | 2016-11-01 00:00:00 | 0.324543664876592
 | Supersize | 2016-11-01 00:00:00 | 0.4530431937172775
 | Vault | 2016-11-01 00:00:00 | 0.328364569146314
 | Winers & Diners | 2016-11-01 00:00:00 | 0.3643695223145478
 | Acquisitions | 2016-12-01 00:00:00 | 0.2905483430731007
 | Business Banking | 2016-12-01 00:00:00 | 0.3038885142728703
 | Cash Investments | 2016-12-01 00:00:00 | 0.5069637883008357
 | Hunters | 2016-12-01 00:00:00 | 0.3962159411574224
 | Supersize | 2016-12-01 00:00:00 | 0.4236690044550306
 | Vault | 2016-12-01 00:00:00 | 0.3526691784508489
 | Winers & Diners | 2016-12-01 00:00:00 | 0.3859863869878892
 | ch33
 | CallCentre | MonthYear | %Diarized
 | Acquisitions | 2016-11-01 00:00:00 | 0.1244314868804665
 | Business Banking | 2016-11-01 00:00:00 | 0.1495783090541577
 | Cash Investments | 2016-11-01 00:00:00 | 0.1654542063047939
 | Hunters | 2016-11-01 00:00:00 | 0.1749005638065648
 | Supersize | 2016-11-01 00:00:00 | 0.1076297993019197
 | Vault | 2016-11-01 00:00:00 | 0.1710797871007094
 | Winers & Diners | 2016-11-01 00:00:00 | 0.1272387062282812
 | Acquisitions | 2016-12-01 00:00:00 | 0.1351786401651678
 | Business Banking | 2016-12-01 00:00:00 | 0.1359856147448865
 | Cash Investments | 2016-12-01 00:00:00 | 0.1493036211699164
 | Hunters | 2016-12-01 00:00:00 | 0.1649858907341444
 | Supersize | 2016-12-01 00:00:00 | 0.1024215958713775
 | Vault | 2016-12-01 00:00:00 | 0.1630376278318736
 | Winers & Diners | 2016-12-01 00:00:00 | 0.1274689812496523
 | ch34
 | CallCentre | MonthYear | %Taken Up
 | Acquisitions | 2016-11-01 00:00:00 | 0.07105221309302942
 | Business Banking | 2016-11-01 00:00:00 | 0.1445598382937199
 | Cash Investments | 2016-11-01 00:00:00 | 0.08711061369147548
 | Hunters | 2016-11-01 00:00:00 | 0.04811774316669122
 | Supersize | 2016-11-01 00:00:00 | 0.1483965968586387
 | Vault | 2016-11-01 00:00:00 | 0.1080706210676716
 | Winers & Diners | 2016-11-01 00:00:00 | 0.1195152052870151
 | Acquisitions | 2016-12-01 00:00:00 | 0.06582216467788782
 | Business Banking | 2016-12-01 00:00:00 | 0.1357608451337379
 | Cash Investments | 2016-12-01 00:00:00 | 0.083008356545961
 | Hunters | 2016-12-01 00:00:00 | 0.04248970717490864
 | Supersize | 2016-12-01 00:00:00 | 0.1498390013673856
 | Vault | 2016-12-01 00:00:00 | 0.13208885844302
 | Winers & Diners | 2016-12-01 00:00:00 | 0.09137780745191862
 | ch36
 | CallCentre | MonthYear | %Not Interested
 | Acquisitions | 2016-11-01 00:00:00 | 0.06682215743440233
 | Business Banking | 2016-11-01 00:00:00 | 0.06022164912525266
 | Cash Investments | 2016-11-01 00:00:00 | 0.08505875769445999
 | Hunters | 2016-11-01 00:00:00 | 0.1445741988188186
 | Supersize | 2016-11-01 00:00:00 | 0.01058027923211169
 | Vault | 2016-11-01 00:00:00 | 0.09977356472623056
 | Winers & Diners | 2016-11-01 00:00:00 | 0.07525579120385378
 | Acquisitions | 2016-12-01 00:00:00 | 0.0784197081569094
 | Business Banking | 2016-12-01 00:00:00 | 0.04922454484153743
 | Cash Investments | 2016-12-01 00:00:00 | 0.09916434540389972
 | Hunters | 2016-12-01 00:00:00 | 0.1552250543553685
 | Supersize | 2016-12-01 00:00:00 | 0.01221825239292488
 | Vault | 2016-12-01 00:00:00 | 0.09813084112149532
 | Winers & Diners | 2016-12-01 00:00:00 | 0.08336578942487806
 | ch37
 | CallCentre | MonthYear | %Enquiry
 | Acquisitions | 2016-11-01 00:00:00 | 0.003116883116883117
 | Business Banking | 2016-11-01 00:00:00 | 0.03108663832160033
 | Cash Investments | 2016-11-01 00:00:00 | 0.02201081887707517
 | Hunters | 2016-11-01 00:00:00 | 3.348019980983246e-05
 | Supersize | 2016-11-01 00:00:00 | 0.03423592931937173
 | Vault | 2016-11-01 00:00:00 | 0.002916085259982788
 | Winers & Diners | 2016-11-01 00:00:00 | 0.0001308103988579683
 | Acquisitions | 2016-12-01 00:00:00 | 0.003009413164432935
 | Business Banking | 2016-12-01 00:00:00 | 0.02944481906046302
 | Cash Investments | 2016-12-01 00:00:00 | 0.01337047353760446
 | Hunters | 2016-12-01 00:00:00 | 0.0001387796641532127
 | Supersize | 2016-12-01 00:00:00 | 0.034890388602179
 | Vault | 2016-12-01 00:00:00 | 0.001908303567059745
 | Winers & Diners | 2016-12-01 00:00:00 | 7.418535210222742e-05
 | ch38
 | CallCentre | MonthYear | %Disqualified
 | Acquisitions | 2016-11-01 00:00:00 | 0.03306652531142327
 | Business Banking | 2016-11-01 00:00:00 | 0.1391928626193629
 | Cash Investments | 2016-11-01 00:00:00 | 0.01828017160977429
 | Hunters | 2016-11-01 00:00:00 | 0.03285746809336958
 | Supersize | 2016-11-01 00:00:00 | 0.1737429101221641
 | Vault | 2016-11-01 00:00:00 | 0.01692833448918375
 | Winers & Diners | 2016-11-01 00:00:00 | 0.02716306369328943
 | Acquisitions | 2016-12-01 00:00:00 | 0.04724078804633097
 | Business Banking | 2016-12-01 00:00:00 | 0.1665542818610924
 | Cash Investments | 2016-12-01 00:00:00 | 0.0116991643454039
 | Hunters | 2016-12-01 00:00:00 | 0.03541194430309479
 | Supersize | 2016-12-01 00:00:00 | 0.2114595739049888
 | Vault | 2016-12-01 00:00:00 | 0.006679062484709106
 | Winers & Diners | 2016-12-01 00:00:00 | 0.03373578886848792
Sheet 2
 | ch41
 | Average Times | MonthYear | Time Spent Per Outcome
 | Avg_TakenUpTime | 2016-11-01 00:00:00 | 0:35:56.292000
 | Avg_TakenUpTime | 2016-12-01 00:00:00 | 0:32:35.844000
 | Avg_NotInterestedTime | 2016-11-01 00:00:00 | 0:05:17.813000
 | Avg_NotInterestedTime | 2016-12-01 00:00:00 | 0:05:10.669000
 | Avg_Diarized | 2016-11-01 00:00:00 | 0:02:35.593000
 | Avg_Diarized | 2016-12-01 00:00:00 | 0:02:18.472000
 | Avg_UncontableTime | 2016-11-01 00:00:00 | 0:04:28.269000
 | Avg_UncontableTime | 2016-12-01 00:00:00 | 0:04:18.260000
 | Avg_DisqualifiedTime | 2016-11-01 00:00:00 | 0:02:45.253000
 | Avg_DisqualifiedTime | 2016-12-01 00:00:00 | 0:02:36.205000
 | ch42
 | CallCentre | MonthYear | Taken Up Time
 | Acquisitions | 2016-11-01 00:00:00 | 1:12:57.902000
 | Business Banking | 2016-11-01 00:00:00 | 1:12:00.313000
 | Cash Investments | 2016-11-01 00:00:00 | 0:25:22.893000
 | Hunters | 2016-11-01 00:00:00 | 0:53:58.263000
 | Supersize | 2016-11-01 00:00:00 | 0:42:57.671000
 | Vault | 2016-11-01 00:00:00 | 0:23:44.295000
 | Winers & Diners | 2016-11-01 00:00:00 | 0:18:32.288000
 | Acquisitions | 2016-12-01 00:00:00 | 1:08:44.087000
 | Business Banking | 2016-12-01 00:00:00 | 1:16:48.326000
 | Cash Investments | 2016-12-01 00:00:00 | 0:22:19.255000
 | Hunters | 2016-12-01 00:00:00 | 0:55:23.606000
 | Supersize | 2016-12-01 00:00:00 | 0:38:46.739000
 | Vault | 2016-12-01 00:00:00 | 0:15:05.750000
 | Winers & Diners | 2016-12-01 00:00:00 | 0:19:37.509000
 | ch43
 | CallCentre | MonthYear | Not Interested Time
 | Acquisitions | 2016-11-01 00:00:00 | 0:05:01.766000
 | Business Banking | 2016-11-01 00:00:00 | 0:05:24.332000
 | Cash Investments | 2016-11-01 00:00:00 | 0:05:29.941000
 | Hunters | 2016-11-01 00:00:00 | 0:04:56.841000
 | Supersize | 2016-11-01 00:00:00 | 0:06:05.777000
 | Vault | 2016-11-01 00:00:00 | 0:05:49.954000
 | Winers & Diners | 2016-11-01 00:00:00 | 0:05:28.479000
 | Acquisitions | 2016-12-01 00:00:00 | 0:04:43.204000
 | Business Banking | 2016-12-01 00:00:00 | 0:05:40.863000
 | Cash Investments | 2016-12-01 00:00:00 | 0:07:30.607000
 | Hunters | 2016-12-01 00:00:00 | 0:04:50.012000
 | Supersize | 2016-12-01 00:00:00 | 0:06:24.693000
 | Vault | 2016-12-01 00:00:00 | 0:05:11.164000
 | Winers & Diners | 2016-12-01 00:00:00 | 0:05:17.710000
 | ch44
 | ch77
 | ch45