Spreadsheet: 674614d1587944923-exploding-date-row-data-pivot-table-raw-data-date-exploding
Sheet: Required Data

CLOSEDATE | RO | SA-NO | TECHNO | LBR-TYPE | OP-CODE | LINE | LABOR
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | REP | A | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | REP | B | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | REP | C | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | REP | D | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | REP | E | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | INFO | F | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | INFO | G | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | INFO | H | 0
2020-03-31 00:00:00 | 509158 | 74 | 39 | IBMPI | MPI | I | 0
2020-03-31 00:00:00 | 509158 | 74 | 99 | IBMPI | REP | J | 0
2020-01-08 00:00:00 | 511725 | 95 | 54 | WBMW | 6121528 | A | 14.7
2020-01-08 00:00:00 | 511725 | 95 | 54 | WBMW | 779 | A | 44.1
2020-01-08 00:00:00 | 511725 | 95 | 54 | WBMW | 12 | A | 147
2020-01-08 00:00:00 | 511725 | 95 | 54 | IBNI | GU | B | 44.1
2020-01-08 00:00:00 | 511725 | 95 | 54 | IBNI | KAHU | C | 51
2020-01-08 00:00:00 | 511725 | 95 | 99 | IBNI | TINT | D | 0
2020-01-08 00:00:00 | 511725 | 95 |  | IBNI | 9999 | D
2020-01-08 00:00:00 | 511725 | 95 | 99 | IBNI | DETAIL | E | 0
2020-01-08 00:00:00 | 511725 | 95 | 54 | IBMPI | INFO | F | 0
2020-01-08 00:00:00 | 511725 | 95 | 54 | WBMW | INFO | G | 911.4
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 6100731 | A | 58.8
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 556 | A | 44.1
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 6100732 | A | 58.8
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 50000 | A | 705.6
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 6577600 | A | 323.4
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 6577560 | A | 29.4
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 6577518 | A | 161.7
2020-01-15 00:00:00 | 513439 | 51 | 86 | WBMW | 6100009 | A | 661.5
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 50000 | A | 323.4
2020-01-15 00:00:00 | 513439 | 51 | 35 | WBMW | 68124 | A | 147
2020-01-15 00:00:00 | 513439 | 51 | 35 | IBMPI | MPI | B | 0
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | UCI | A | 340
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | SMOG | B | 35
2020-01-09 00:00:00 | 513837 | 95 |  | IBUNC | 9997 | B
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | KAHU | C | 51
2020-01-09 00:00:00 | 513837 | 95 | 99 | IBUNC | DETAIL | D | 0
2020-01-09 00:00:00 | 513837 | 95 | 54 | WBMW | 67933 | E | 44.1
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | BF | F | 170
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | INFO | G | 1890
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | INFO | H | 0
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | INFO | I | 306
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | INFO | J | 0
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | [NAME] | K | 149.95
2020-01-09 00:00:00 | 513837 | 95 | 99 | IBUNC | SUBLET | L | 0
2020-01-09 00:00:00 | 513837 | 95 |  | IBUNC | 9999 | L
2020-01-09 00:00:00 | 513837 | 95 | 54 | IBUNC | BATT | M | 170
2020-01-09 00:00:00 | 513837 | 95 | 54 | WBMW | 1700509 | N | 29.4
2020-01-09 00:00:00 | 513837 | 95 | 54 | WBMW | 1151508 | N | 999.6
2020-01-09 00:00:00 | 513841 | 22 | 57 | CBPM | DIAGS | A | 99.95
2020-01-09 00:00:00 | 513841 | 22 | 57 | IBMPI | REP | B | 0
2020-01-09 00:00:00 | 513841 | 22 | 57 | IBMPI | MPI | C | 0
2020-01-15 00:00:00 | 513942 | 156 | 40 | WBMW | 65252 | A | 323.4
2020-01-15 00:00:00 | 513942 | 156 | 40 | WBMW | 65790 | B | 132.3
2020-01-15 00:00:00 | 513942 | 156 | 40 | CBUR | DIAGS | C | 99.95
2020-01-15 00:00:00 | 513942 | 156 |  | CBUR | 9998 | C
2020-01-15 00:00:00 | 513942 | 156 | 40 | CBUR | DIAGS | D | 99.95
2020-01-15 00:00:00 | 513942 | 156 | 40 | IBMPI | MPI | E | 0
2020-01-15 00:00:00 | 513942 | 156 | 40 | CBPM | MAINT | F | 0
2020-01-15 00:00:00 | 513942 | 156 | 40 | CBUR | REP | G | 261
2020-01-15 00:00:00 | 513942 | 156 | 40 | CBUR | REP | H | 362.5
2020-01-02 00:00:00 | 514077 | 29 |  | CBPM | 9997 | A
2020-01-02 00:00:00 | 514077 | 29 | 37 | CBPM | LOF4 | A | 49.95
2020-01-02 00:00:00 | 514077 | 29 | 37 | IBMPI | FL33 | B | 0
2020-01-02 00:00:00 | 514077 | 29 | 37 | IBMPI | MPI | C | 0
2020-01-02 00:00:00 | 514077 | 29 | 37 | CBUR | EE08 | D | 170
2020-01-09 00:00:00 | 514078 | 29 | 55 | CEXTO | MAINT | A | 221
2020-01-09 00:00:00 | 514078 | 29 | 55 | IBMPI | MPI | B | 0
2020-01-09 00:00:00 | 514078 | 29 | 55 | CBUR | EL10 | C | 170
2020-01-03 00:00:00 | 514137 | 51 | 37 | WBMW | 6121528 | A | 14.7
2020-01-03 00:00:00 | 514137 | 51 | 37 | WBMW | 6100009 | A | 29.4
2020-01-03 00:00:00 | 514137 | 51 | 37 | WBMW | 6131512 | A | 88.2
2020-01-03 00:00:00 | 514137 | 51 | 37 | WBMW | 6 | A | 58.8
2020-01-03 00:00:00 | 514137 | 51 | 37 | IBMPI | MPI | B | 0
2020-01-06 00:00:00 | 514145 | 95 | 80 | IOUSD | UCI | A | 170
2020-01-06 00:00:00 | 514145 | 95 | 55 | IOUSD | SMOG | B | 35
2020-01-06 00:00:00 | 514145 | 95 |  | IOUSD | 9997 | B
2020-01-06 00:00:00 | 514145 | 95 | 56 | IOUSD | KAHU | C | 51
2020-01-06 00:00:00 | 514145 | 95 | 99 | IOUSD | DETAIL | D | 0
2020-01-06 00:00:00 | 514145 | 95 | 56 | IOUSD | ILOF | E | 85
2020-01-06 00:00:00 | 514145 | 95 | 56 | IOUSD | INFO | F | 340
2020-01-11 00:00:00 | 514176 | 74 | 54 | CBPM | [NAME] | A | 149.95
2020-01-11 00:00:00 | 514176 | 74 | 54 | CBUR | REP | A | 1258
2020-01-11 00:00:00 | 514176 | 74 | 54 | IBMPI | REP | B | 0
2020-01-11 00:00:00 | 514176 | 74 | 54 | IBMPI | MPI | C | 0
2020-01-11 00:00:00 | 514176 | 74 | 54 | CBUR | REP | D | 1071
2020-01-11 00:00:00 | 514176 | 74 |  | CBUR | 9997 | D
2020-01-13 00:00:00 | 514177 | 22 | 34 | WBMW | 5134192 | A | 499.8
2020-01-13 00:00:00 | 514177 | 22 | 34 | IBMPI | LW | B | 0
2020-01-13 00:00:00 | 514177 | 22 | 34 | WBMW | 50000 | C | 588
2020-01-13 00:00:00 | 514177 | 22 | 34 | IBMPI | REP | D | 0
2020-01-13 00:00:00 | 514177 | 22 | 34 | WBMW | 5413585 | E | 720.3
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6121528 | A | 14.7
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6653681 | A | 29.4
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6100730 | A | 58.8
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6120908 | A | 14.7
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6100731 | A | 58.8
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6699000 | A | 58.8
2020-01-03 00:00:00 | 514179 | 22 | 57 | WBMW | 6 | A | 58.8
2020-01-03 00:00:00 | 514179 | 22 | 57 | IBMPI | SOP | B | 0