Spreadsheet: 699658d1602694426-how-to-split-raw-data-based-on-value-of-a-cell-test
Sheet: Raw Data

s_id | associate_task | associate_queue | associate | associate_resolve_time | metric_wk_no | a_action | investigator_task | investigator_queue | investigator | investigator_resolve_time | metric_wk_no | verification_action | country | merchant_program_at_reg | associate_country | hire_to_task | in_ramp_phase | m_customer_id | language
A2X2B2J1EHR82E | 20000249971454 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 23:12:04 | 41 | Transfered Task | 20000250737526 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 23:14:34 | 41 | RFI/RFD |  | PROFESSIONAL | NON - CN | 101.97 | N | 9649177605 | OTHER
A22YM11V48DKLB | 20000248585638 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-03 00:04:40 | 41 | Transfered Task | 20000248589247 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-03 11:47:37 | 40 | Approved SIV |  | PROFESSIONAL | NON - CN | 96 | N | 18251455205 | EN
A133Q942Z59IE7 | 20000250312367 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 20:22:26 | 41 | Transfered Task | 20000250314310 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-07 23:07:36 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 100.85 | N | 692466806 | OTHER
A16B7CSV3O1Y28 | 20000248498053 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-02 18:22:58 | 41 | Transfered Task | 20000248500658 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-03 10:23:27 | 40 | Approved SIV | US | PROFESSIONAL | NON - CN | 95.77 | N | 225037562402 | EN
A3RHLF9KIIL9I9 | 20000250213372 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-09 16:44:26 | 41 | Transfered Task | 20000251003871 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-09 16:47:57 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 102.7 | N | 267276421902 | OTHER
A3V5G5WEF0LAD7 | 20000250627362 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 17:17:44 | 41 | Transfered Task | 20000250630130 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 18:38:26 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 101.72 | N | 266328470602 | OTHER
A8URY03R2D6II | 20000248058521 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 12:19:27 | 41 | Transfered Task | 20000249405076 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-05 12:35:45 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 63.51 | N | 265177256402 | EN
AC9T65Q7Z4P53 | 20000249411803 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 12:53:25 | 41 | Transfered Task | 20000249413028 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-05 13:38:07 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 63.54 | N | 8056229105 | EN
A25AMIMROC59DX | 20000249944760 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-09 14:11:37 | 41 | Transfered Task | 20000250959135 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-09 14:16:06 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 67.59 | N | 266939836802 | OTHER
A29T2TI0CL174K | 20000249435269 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 14:58:46 | 41 | Transfered Task | 20000250216113 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-07 19:32:31 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 65.62 | N | 266561757702 | OTHER
A3C84IE3TTG0JO | 20000246942082 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 14:17:22 | 41 | Transfered Task | 20000249435434 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-05 14:36:56 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 63.6 | N | 264123626302 | EN
A1RCNF3HSMO0D4 | 20000249784896 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-06 12:53:07 | 41 | Transfered Task | 20000249786707 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 14:07:56 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 64.54 | N | 708116766 | EN
A3KNNVOFMHLG7C | 20000249967784 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 22:36:22 | 41 | Transfered Task | 20000250729349 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 22:37:19 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 87.94 | N | 25079279005 | OTHER
[NAME] | 20000249598108 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 23:13:26 | 41 | Transfered Task | 20000249598650 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 13:34:09 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 84.97 | N | 26204731815 | EN
A1MAAJUCT3N4TL | 20000239592846 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 18:04:18 | 41 | Transfered Task | 20000249508625 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 11:40:21 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 84.75 | N | 9751177805 | EN
A1UJOYHVLZLXKC | 20000247825363 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 16:07:58 | 41 | Transfered Task | 20000249468610 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 10:05:58 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 84.67 | N | 1063722046 | EN
A2IRNJR8MF87G1 | 20000249591563 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 22:45:39 | 41 | Transfered Task | 20000249592177 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 13:23:47 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 84.95 | N | 19951737405 | EN
A1L8QHIKABDRX3 | 20000249669739 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 17:06:16 | 41 | Transfered Task | 20000250626242 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 18:00:21 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 87.71 | N | 266798188002 | OTHER
A3LC4P3HOR200F | 20000248927615 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 19:15:07 | 41 | Transfered Task | 20000250666061 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 19:26:39 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 66.8 | N | 265846966502 | OTHER
A3AI3545F1X5RM | 20000249492191 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 17:44:18 | 41 | Transfered Task | 20000250268462 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-07 21:30:00 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 86.74 | N | 265677082702 | OTHER
A10CF3EDMVYRIU | 20000249290966 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 18:03:38 | 41 | Transfered Task | 20000250274432 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-07 21:35:10 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 86.75 | N | 255673744002 | OTHER
A1CCD1R3606ET5 | 20000250711011 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 21:23:48 | 41 | Transfered Task | 20000250712161 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 21:39:47 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 87.89 | N | 265992064302 | OTHER
AYVJWKGGPVPCX | 20000249441114 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 14:44:25 | 41 | Transfered Task | 20000249443302 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-05 15:24:47 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 63.61 | N | 296389866 | EN
A330N2SPXHNIJM | 20000249955624 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 22:18:56 | 41 | Transfered Task | 20000250725423 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 22:30:28 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 87.93 | N | 261514176702 | EN
A1ALPT8ATXTG1G | 20000248238620 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-09 14:10:08 | 41 | Transfered Task | 20000250958803 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-09 14:16:15 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 67.59 | N | 265186671102 | EN
A358KMENRP9CBK | 20000249629564 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 18:42:45 | 41 | Transfered Task | 20000250657682 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 19:12:48 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 87.78 | N | 266751828502 | OTHER
A27N8BRJH1A0I8 | 20000250098121 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 06:54:43 | 41 | Video call did not happen/ Task Trasnfered | 20000250105061 | US_Compliance_VerifiedId_Approval_JP | Doesn’t matter | 2020-10-07 08:22:25 | 41 | Approved SIV | JP | PROFESSIONAL | NON - CN | 338.29 | N | 246288995002 | JP
A3RKTAQJHXVTZ0 | 20000247822422 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 15:15:17 | 41 | Transfered Task | 20000249452293 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-05 15:35:45 | 41 | RFI/RFD | US | PROFESSIONAL | NON - CN | 63.64 | N | 9082778005 | EN
A1SLB28WDREHSF | 20000244738008 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-09 09:11:25 | 41 | Transfered Task | 20000250878146 | US_Compliance_VerifiedId_Approval_CN | Doesn’t matter | 2020-10-09 09:31:04 | 41 | Approved SIV | CN | PROFESSIONAL | CN | 46.38 | N | 261273295602 | CN
A2JGR4ITA4FF1Z | 20000249534527 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 14:07:48 | 41 | Transfered Task | 20000250572038 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 14:19:03 | 41 | Approved SIV | US | PROFESSIONAL | NON - CN | 66.59 | N | 265048804402 | EN
AMGGYLLVBPPHN | 20000249539892 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-05 19:53:18 | 41 | Transfered Task | 20000249543704 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 12:36:26 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 63.83 | N | 46531016715 | OTHER
A11G0NAOJ46G95 | 20000249538738 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 20:13:58 | 41 | Transfered Task | 20000250311996 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-07 23:04:29 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 65.84 | N | 216281438802 | OTHER
AA3GBTXOCRS2K | 20000251003496 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-09 16:58:26 | 41 | Transfered Task | 20000251008269 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-09 17:02:13 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 67.71 | N | 102192650 | OTHER
[NAME] | 20000249278081 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 19:53:00 | 41 | Transfered Task | 20000250679048 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 19:56:29 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 66.83 | N | 123466671402 | OTHER
A2ZY5FLSVC1BEL | 20000250261465 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-07 17:46:53 | 41 | Transfered Task | 20000250269263 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-07 21:31:27 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 65.74 | N | 266568908202 | OTHER
A2QVWI7307CW0O | 20000250776860 | US_Compliance_VerifiedId_ID_Meeting_CN | Doesn’t matter | 2020-10-09 01:50:16 | 41 | Transfered Task | 20000250778084 | US_Compliance_VerifiedId_Approval_CN | Doesn’t matter | 2020-10-09 03:08:47 | 41 | Approved SIV | CN | PROFESSIONAL | CN | 46.08 | N | 264813672402 | CN
AECRGXIORENCL | 20000249979189 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 23:47:22 | 41 | Transfered Task | 20000250745746 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 23:55:25 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 101.99 | N | 55644685202 | OTHER
A1P75TNSI4PKYT | 20000249612412 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-08 15:42:54 | 41 | Transfered Task | 20000250600355 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-08 17:09:38 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 101.65 | N | 266744714102 | OTHER
A1L0FA5A4ZFGBI | 20000249228793 | US_Compliance_VerifiedId_Meeting | Doesn’t matter | 2020-10-06 23:45:43 | 41 | Transfered Task | 20000249988061 | US_Compliance_VerifiedId_Approval_ROW | Doesn’t matter | 2020-10-06 23:47:49 | 41 | RFI/RFD | OTHER | PROFESSIONAL | NON - CN | 99.99 | N | 816766386 | OTHER