Spreadsheet: 233800d1367933221-take-certain-data-from-invoice-xls-and-show-on-different-sheet-april-2013-wex-invoice-solution
Sheet: SCS

 | Group | scs
 |  | Card Number | Vehicle Card Department | Customer Vehicle ID | Transaction Date | Transaction Time | Unit Cost | Fuel Cost | Net Cost (=)
 | 1 | 0292 - 1 | SCS | 795 | 2013-04-08 00:00:00 | 16:14:09 | 4 | 65.84 | 58.38
 | 2 | 0292 - 1 | SCS | 795 | 2013-04-24 00:00:00 | 08:07:52 | 3.88 | 58.63 | 54.96
 | 3 | 0292 - 1 | SCS | 795 | 2013-04-23 00:00:00 | 06:40:31 | 3.98 | 71.37 | 63.24
 | 4 | 0292 - 1 | SCS | 795 | 2013-04-01 00:00:00 | 08:15:25 | 4.1 | 48.83 | 43.44
 | 5 | 0292 - 1 | SCS | 795 | 2013-04-22 00:00:00 | 06:38:11 | 4 | 77.81 | 68.99
 | 6 | 0292 - 1 | SCS | 795 | 2013-04-25 00:00:00 | 09:49:00 | 4 | 67.59 | 63.48
 | 7 | 0292 - 1 | SCS | 795 | 2013-04-11 00:00:00 | 16:15:23 | 4 | 75.2 | 66.68
 | 8 | 0291 - 1 | SCS | 794 | 2013-04-08 00:00:00 | 13:49:25 | 3.85 | 86 | 80.57
 | 9 | 0291 - 1 | SCS | 794 | 2013-04-25 00:00:00 | 10:04:42 | 3.7 | 94 | 82.49
 | 10 | 0291 - 1 | SCS | 794 | 2013-04-12 00:00:00 | 10:13:02 | 3.83 | 95 | 83.76
 | 11 | 0278 - 1 | SCS | 789 | 2013-04-24 00:00:00 | 09:31:37 | 0 | 0 | 0
 | 12 | 0278 - 1 | SCS | 789 | 2013-04-17 00:00:00 | 19:36:49 | 3.75 | 111.99 | 106.52
 | 13 | 0278 - 1 | SCS | 789 | 2013-04-05 00:00:00 | 17:22:15 | 3.46 | 87.52 | 82.89
 | 14 | 0278 - 1 | SCS | 789 | 2013-04-26 00:00:00 | 13:13:53 | 3.37 | 70.97 | 67.11
 | 15 | 0278 - 1 | SCS | 789 | 2013-04-02 00:00:00 | 14:47:00 | 0 | 0 | 0
 | 16 | 0278 - 1 | SCS | 789 | 2013-04-02 00:00:00 | 13:39:05 | 3.5 | 77.96 | 73.88
 | 17 | 0278 - 1 | SCS | 789 | 2013-04-19 00:00:00 | 15:41:04 | 0 | 0 | 0
 | 18 | 0278 - 1 | SCS | 789 | 2013-04-19 00:00:00 | 17:15:05 | 3.67 | 77.24 | 73.39
 | 19 | 0278 - 1 | SCS | 789 | 2013-04-11 00:00:00 | 12:54:35 | 3.4 | 91.86 | 86.91
 | 20 | 0278 - 1 | SCS | 789 | 2013-04-23 00:00:00 | 15:26:00 | 3.24 | 84.76 | 84.76
 | 21 | 0277 - 1 | SCS | 788 | 2013-04-03 00:00:00 | 11:31:35 | 3.39 | 82 | 77.57
 | 22 | 0277 - 1 | SCS | 788 | 2013-04-15 00:00:00 | 10:35:42 | 3.38 | 92 | 87.02
 | 23 | 0277 - 1 | SCS | 788 | 2013-04-22 00:00:00 | 11:12:16 | 3.38 | 72 | 68.1
 | 24 | 0277 - 1 | SCS | 788 | 2013-04-24 00:00:00 | 10:35:52 | 3.34 | 75 | 70.89
 | 25 | 0276 - 1 | SCS | 787 | 2013-04-25 00:00:00 | 08:55:18 | 3.27 | 101 | 95.35
 | 26 | 0275 - 1 | SCS | 786 | 2013-04-16 00:00:00 | 08:42:00 | 3.4 | 90.97 | 86.07
 | 27 | 0275 - 1 | SCS | 786 | 2013-04-26 00:00:00 | 08:58:00 | 3.16 | 81.2 | 76.5
 | 28 | 0275 - 1 | SCS | 786 | 2013-04-22 00:00:00 | 08:53:00 | 3.4 | 52.6 | 49.77
 | 29 | 0275 - 1 | SCS | 786 | 2013-04-02 00:00:00 | 16:56:00 | 3.4 | 60.86 | 57.58
 | 30 | 0274 - 1 | SCS | 785 | 2013-04-02 00:00:00 | 08:16:56 | 3.55 | 42 | 39.83
 | 31 | 0274 - 1 | SCS | 785 | 2013-04-05 00:00:00 | 10:01:50 | 3.55 | 29 | 27.5
 | 32 | 0274 - 1 | SCS | 785 | 2013-04-17 00:00:00 | 10:39:48 | 3.4 | 79.79 | 75.49
 | 33 | 0274 - 1 | SCS | 785 | 2013-04-15 00:00:00 | 10:16:00 | 3.42 | 34 | 32.18
 | 34 | 0274 - 1 | SCS | 785 | 2013-04-25 00:00:00 | 15:37:30 | 3.5 | 85 | 80.55
 | 35 | 0274 - 1 | SCS | 785 | 2013-04-11 00:00:00 | 08:07:12 | 3.55 | 100 | 94.84
 | 36 | 0274 - 1 | SCS | 785 | 2013-04-19 00:00:00 | 11:57:00 | 3.44 | 50 | 47.34
 | 37 | 0274 - 1 | SCS | 785 | 2013-04-09 00:00:00 | 07:48:00 | 3.38 | 58 | 54.86
 | 38 | 0261 - 1 | SCS | 772 | 2013-04-18 00:00:00 | 13:55:25 | 3.81 | 72.53 | 67.9
 | 39 | 0261 - 1 | SCS | 772 | 2013-04-08 00:00:00 | 19:01:52 | 4.16 | 75.32 | 70.92
 | 40 | 0261 - 1 | SCS | 772 | 2013-04-08 00:00:00 | 07:46:18 | 4 | 49.09 | 43.53
 | 41 | 0261 - 1 | SCS | 772 | 2013-04-26 00:00:00 | 07:55:19 | 3.66 | 66.45 | 58.23
 | 42 | 0261 - 1 | SCS | 772 | 2013-04-01 00:00:00 | 14:21:07 | 4.1 | 68.81 | 64.73
 | 43 | 0261 - 1 | SCS | 772 | 2013-04-24 00:00:00 | 06:54:56 | 3.6 | 54.13 | 47.32
 | 44 | 0261 - 1 | SCS | 772 | 2013-04-12 00:00:00 | 10:23:31 | 4 | 68.11 | 63.97
 | 45 | 0261 - 1 | SCS | 772 | 2013-04-30 00:00:00 | 17:38:53 | 3.81 | 63.99 | 56.38
 | 46 | 0260 - 1 | SCS | 771 | 2013-04-15 00:00:00 | 08:21:00 | 3.9 | 54 | 47.72
 | 47 | 0260 - 1 | SCS | 771 | 2013-04-30 00:00:00 | 07:18:00 | 3.88 | 96 | 89.99
 | 48 | 0260 - 1 | SCS | 771 | 2013-04-04 00:00:00 | 14:01:00 | 3.96 | 84.01 | 74.39
 | 49 | 0260 - 1 | SCS | 771 | 2013-04-30 00:00:00 | 12:21:29 | 3.84 | 30 | 26.46
 | 50 | 0260 - 1 | SCS | 771 | 2013-04-26 00:00:00 | 13:17:00 | 3.62 | 80 | 69.99
 | 51 | 0260 - 1 | SCS | 771 | 2013-04-19 00:00:00 | 12:18:19 | 3.7 | 64 | 60.83
 | 52 | 0256 - 1 | SCS | 767 | 2013-04-29 00:00:00 | 09:54:29 | 3.36 | 78.99 | 74.69
 | 53 | 0256 - 1 | SCS | 767 | 2013-04-04 00:00:00 | 16:32:00 | 3.42 | 76.4 | 72.31
 | 54 | 0256 - 1 | SCS | 767 | 2013-04-19 00:00:00 | 09:47:03 | 3.4 | 82.74 | 78.29
 | 55 | 0256 - 1 | SCS | 767 | 2013-04-11 00:00:00 | 13:20:00 | 3.46 | 82.19 | 77.84
 | 56 | 0256 - 1 | SCS | 767 | 2013-04-23 00:00:00 | 12:14:00 | 3.22 | 43.75 | 41.26
 | 57 | 0244 - 1 | SCS | 751 | 2013-04-17 00:00:00 | 14:19:00 | 3.95 | 77 | 68.17
 | 58 | 0244 - 1 | SCS | 751 | 2013-04-01 00:00:00 | 14:10:00 | 4.2 | 50 | 47.11
 | 59 | 0244 - 1 | SCS | 751 | 2013-04-08 00:00:00 | 10:20:13 | 4.1 | 66.01 | 58.72
 | 60 | 0244 - 1 | SCS | 751 | 2013-04-05 00:00:00 | 10:39:37 | 3.88 | 55 | 52.41
 | 61 | 0244 - 1 | SCS | 751 | 2013-04-30 00:00:00 | 09:10:48 | 3.9 | 70.01 | 61.88
 | 62 | 0244 - 1 | SCS | 751 | 2013-04-24 00:00:00 | 10:51:00 | 3.8 | 73.01 | 64.3
 | 63 | 0243 - 1 | SCS | 750 | 2013-04-17 00:00:00 | 11:53:00 | 4.2 | 54.5 | 48.62
 | 64 | 0243 - 1 | SCS | 750 | 2013-04-15 00:00:00 | 10:51:00 | 4.3 | 99 | 88.56
 | 65 | 0243 - 1 | SCS | 750 | 2013-04-30 00:00:00 | 08:14:00 | 3.78 | 53 | 46.64
 | 66 | 0243 - 1 | SCS | 750 | 2013-04-22 00:00:00 | 08:12:40 | 4 | 66 | 61.99
 | 67 | 0243 - 1 | SCS | 750 | 2013-04-23 00:00:00 | 17:16:41 | 3.9 | 68 | 63.76
 | 68 | 0243 - 1 | SCS | 750 | 2013-04-09 00:00:00 | 09:13:00 | 4.3 | 100.01 | 89.47
 | 69 | 0243 - 1 | SCS | 750 | 2013-04-01 00:00:00 | 16:08:00 | 3.96 | 80 | 70.85
 | 70 | 0243 - 1 | SCS | 750 | 2013-04-26 00:00:00 | 15:39:00 | 3.6 | 70 | 61.19
 | 71 | 0230 - 1 | SCS | 731 | 2013-04-19 00:00:00 | 08:45:00 | 3.9 | 108 | 95.45
 | 72 | 0230 - 1 | SCS | 731 | 2013-04-05 00:00:00 | 17:34:03 | 4.1 | 114 | 107.24
 | 73 | 0223 - 2 | SCS | 730 | 2013-04-09 00:00:00 | 12:45:17 | 3.96 | 115 | 101.84
 | 74 | 0223 - 2 | SCS | 730 | 2013-04-24 00:00:00 | 09:51:10 | 3.64 | 69.5 | 64.86
 | 75 | 0062 - 1 | SCS | 598 | 2013-04-25 00:00:00 | 14:11:37 | 3.26 | 62.42 | 58.92
 | 76 | 0048 - 2 | SCS | 584 | 2013-04-19 00:00:00 | 13:32:54 | 3.67 | 295 | 275.46
 | 77 | 0048 - 2 | SCS | 584 | 2013-04-04 00:00:00 | 11:12:03 | 3.88 | 250 | 234.34
 | 78 | 0048 - 2 | SCS | 584 | 2013-04-15 00:00:00 | 16:13:00 | 3.83 | 200 | 187.31
 | 79 | 0048 - 2 | SCS | 584 | 2013-04-15 00:00:00 | 14:51:00 | 3.46 | 55.87 | 52.91
 | 80 | 0026 - 2 | SCS | 562 | 2013-04-09 00:00:00 | 15:39:00 | 3.4 | 42.61 | 40.32
 | 81 | 0275 - 1 | SCS | 786 | 2013-04-29 00:00:00 | 13:30:30 | 0 | 0 | 0
 | 82 | 0261 - 1 | SCS | 772 | 2013-04-12 00:00:00 | 11:45:17 | 0 | 0 | 0
 | 83 | 0230 - 1 | SCS | 731 | 2013-04-19 00:00:00 | 11:07:57 | 0 | 0 | 0
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100