Spreadsheet: 845986d1697281793-creating-a-summary-table-out-of-a-raw-data-with-a-complex-criteria-summary
Sheet: Sheet1

 |  |  | RAW DATA |  |  |  |  |  |  |  |  |  |  |  | SUMMARY
 | Helper 1 | Helper 2 | MessageType | CreationDate | UpdateDate |  |  |  |  |  |  |  |  |  | MessageType | Volume | CreationDate | UpdateDate
CODA |  |  |  | 02/06/2021 10:05:28:526 | 02/06/2021 10:05:29:527 |  |  |  |  |  |  |  |  |  |  | 1
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521 |  |  |  |  |  |  |  |  |  | 1-MESF | 16
MESF |  |  |  | 02/06/2021 10:05:32:528 | 02/06/2021 10:05:32:528 |  |  |  |  |  |  |  |  |  | 1-DECA | 1
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521 |  |  |  |  |  |  |  |  |  | 1-SEFP | 21
MESF |  |  |  | 02/06/2021 10:05:32:529 | 02/06/2021 10:05:32:529 |  |  |  |  |  |  |  |  |  | 2-MESF | 5
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521 |  |  |  |  |  |  |  |  |  | 2-SEFP | 3
MESF |  |  |  | 02/06/2021 10:05:32:530 | 02/06/2021 10:05:32:530
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521
MESF |  |  |  | 02/06/2021 10:05:32:531 | 02/06/2021 10:05:32:531
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521
MESF |  |  |  | 02/06/2021 10:05:32:532 | 02/06/2021 10:05:32:532
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521
MESF |  |  |  | 02/06/2021 10:05:32:533 | 02/06/2021 10:05:32:533
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521
MESF |  |  |  | 02/06/2021 10:05:32:534 | 02/06/2021 10:05:32:534
MESF |  |  |  | 02/06/2021 10:05:30:521 | 02/06/2021 10:05:30:521
MESF |  |  |  | 02/06/2021 10:05:32:535 | 02/06/2021 10:05:32:535
DECA |  |  |  | 02/06/2021 10:05:34:778 | 02/06/2021 10:05:39:779
SEFP |  |  |  | 02/06/2021 10:06:39:879 | 02/06/2021 10:06:39:879
SEFP |  |  |  | 02/06/2021 10:06:39:891 | 02/06/2021 10:06:39:891
SEFP |  |  |  | 02/06/2021 10:06:39:903 | 02/06/2021 10:06:39:903
SEFP |  |  |  | 02/06/2021 10:06:39:915 | 02/06/2021 10:06:39:915
SEFP |  |  |  | 02/06/2021 10:06:39:927 | 02/06/2021 10:06:39:927
SEFP |  |  |  | 02/06/2021 10:06:39:939 | 02/06/2021 10:06:39:939
SEFP |  |  |  | 02/06/2021 10:06:39:951 | 02/06/2021 10:06:39:951
SEFP |  |  |  | 02/06/2021 10:06:39:963 | 02/06/2021 10:06:39:963
SEFP |  |  |  | 02/06/2021 10:06:39:975 | 02/06/2021 10:06:39:975
SEFP |  |  |  | 02/06/2021 10:06:39:987 | 02/06/2021 10:06:39:987
SEFP |  |  |  | 02/06/2021 10:06:39:999 | 02/06/2021 10:06:39:999
SEFP |  |  |  | 02/06/2021 10:06:39:101 | 02/06/2021 10:06:39:101
SEFP |  |  |  | 02/06/2021 10:06:39:102 | 02/06/2021 10:06:39:102
SEFP |  |  |  | 02/06/2021 10:06:39:103 | 02/06/2021 10:06:39:103
SEFP |  |  |  | 02/06/2021 10:06:39:104 | 02/06/2021 10:06:39:104
SEFP |  |  |  | 02/06/2021 10:06:39:105 | 02/06/2021 10:06:39:105
SEFP |  |  |  | 02/06/2021 10:06:39:107 | 02/06/2021 10:06:39:107
SEFP |  |  |  | 02/06/2021 10:06:39:108 | 02/06/2021 10:06:39:108
SEFP |  |  |  | 02/06/2021 10:06:39:109 | 02/06/2021 10:06:39:109
SEFP |  |  |  | 02/06/2021 10:06:39:110 | 02/06/2021 10:06:39:110
SEFP |  |  |  | 02/06/2021 10:06:39:111 | 02/06/2021 10:06:39:111
MESF |  |  |  | 02/06/2021 10:06:40:111 | 02/06/2021 10:06:40:111
MESF |  |  |  | 02/06/2021 10:06:42:125 | 02/06/2021 10:06:42:125
MESF |  |  |  | 02/06/2021 10:06:45:189 | 02/06/2021 10:06:45:189
MESF |  |  |  | 02/06/2021 10:06:47:789 | 02/06/2021 10:06:47:789
MESF |  |  |  | 02/06/2021 10:06:48:799 | 02/06/2021 10:06:48:799
SEFP |  |  |  | 02/06/2021 10:07:05:589 | 02/06/2021 10:07:05:589
SEFP |  |  |  | 02/06/2021 10:07:06:591 | 02/06/2021 10:07:06:591
SEFP |  |  |  | 02/06/2021 10:07:06:700 | 02/06/2021 10:07:06:700
 |  |  |  | 10,000 rows of data