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

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