Spreadsheet: 538177d1505437810-pulling-unique-data-from-a-table-a-certain-number-of-times-advanced-interpretting-data-1-
Sheet: Source Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automated Result |  |  |  |  |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Month: |  |  |  |  |  |  | Last Month:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Names | Name | Project | Cost Code | Hours |  |  | All Names | Names | Project | Cost Code | Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | [NAME] | 252 - Kay Rd Cutdown | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jury [NAME] |  |  |  |  |  |  | Jury [NAME] | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 250 - 132 Kay Rd Subdivision | 06-Concrete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 252 - Kay Rd Cutdown | 07-Environmental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jury [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jury [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jury [NAME] | 252 - Kay Rd Cutdown | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jury [NAME] | 252 - Kay Rd Cutdown | 07-Environmental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source Data |  |  |  |  |  |  | Reformatted, Intermediate Data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Datestamp | Name | Job 1 | Code 1 | Hours |  |  | Jobs | Job Codes | [NAME] | [NAME] | [NAME] | Jury [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-18 00:00:00 | [NAME] | 247 - Dixon Stage 5 | 08-Other | 10 |  |  | 001 - Overheads | 100-Meetings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-19 00:00:00 | Jury [NAME] | 252 - Kay Rd Cutdown | 02-Roading | 9 |  |  | 001 - Overheads | 101-Machinery Maintenance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-20 00:00:00 | [NAME] | 247 - Dixon Stage 5 | 08-Other | 3 |  |  | 250 - 132 Kay Rd Subdivision | 01-Earthworks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-21 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 3 |  |  | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-22 00:00:00 | Jury [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 9 |  |  | 250 - 132 Kay Rd Subdivision | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-23 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 6 |  |  | 250 - 132 Kay Rd Subdivision | 04-Sewer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-24 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 7 |  |  | 250 - 132 Kay Rd Subdivision | 05-Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-25 00:00:00 | Jury [NAME] | 250 [NAME] | 07-Environmental | 5 |  |  | 250 - 132 Kay Rd Subdivision | 06-Concrete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-26 00:00:00 | [NAME] | 253 - 116 Kay Rd Subdivision | 07-Environmental | 10 |  |  | 250 - 132 Kay Rd Subdivision | 07-Environmental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-27 00:00:00 | Jury [NAME] | 252 - Kay Rd Cutdown | 07-Environmental | 1 |  |  | 250 - 132 Kay Rd Subdivision | 08-Variation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-28 00:00:00 | [NAME] | 252 - Kay Rd Cutdown | 03-Stormwater | 1 |  |  | 250 - 132 Kay Rd Subdivision | 09-Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-29 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 7 |  |  | 250 - 132 Kay Rd Subdivision | 10-Meeting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-30 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 2 |  |  | 250 - 132 Kay Rd Subdivision | 11-Management (On-site)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-31 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 2 |  |  | 250 - 132 Kay Rd Subdivision | 12-Management (Off-site)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-01 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 7 |  |  | 250 - 132 Kay Rd Subdivision | 13-Survey
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-02 00:00:00 | [NAME] | 252 - Kay Rd Cutdown | 07-Environmental | 10 |  |  | 252 - Kay Rd Cutdown | 01-Earthworks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-03 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 5 |  |  | 252 - Kay Rd Cutdown | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-04 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 10 |  |  | 252 - Kay Rd Cutdown | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-05 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 10 |  |  | 252 - Kay Rd Cutdown | 04-Sewer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-06 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 06-Concrete | 9 |  |  | 252 - Kay Rd Cutdown | 05-Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-07 00:00:00 | [NAME] | 001 - Office | 08-Other | 10 |  |  | 252 - Kay Rd Cutdown | 06-Concrete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-08 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 4 |  |  | 252 - Kay Rd Cutdown | 07-Environmental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-09 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 6 |  |  | 252 - Kay Rd Cutdown | 08-Variation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-10 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 10 |  |  | 252 - Kay Rd Cutdown | 09-Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-11 00:00:00 | [NAME] | 252 - Kay Rd Cutdown | 02-Roading | 6 |  |  | 252 - Kay Rd Cutdown | 10-Meeting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-12 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 5 |  |  | 252 - Kay Rd Cutdown | 11-Management (On-site)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-13 00:00:00 | Jury [NAME] | 252 - Kay Rd Cutdown | 02-Roading | 6 |  |  | 252 - Kay Rd Cutdown | 12-Management (Off-site)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-14 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 08-Other | 10 |  |  | 252 - Kay Rd Cutdown | 13-Survey
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-15 00:00:00 | [NAME] | 252 - Kay Rd Cutdown | 08-Other | 1 |  |  | 253 - 116 Kay Rd Subdivision | 01-Earthworks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-16 00:00:00 | Jury [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 3 |  |  | 253 - 116 Kay Rd Subdivision | 02-Roading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-17 00:00:00 | [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 3 |  |  | 253 - 116 Kay Rd Subdivision | 03-Stormwater
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-18 00:00:00 | Jury [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 2 |  |  | 253 - 116 Kay Rd Subdivision | 04-Sewer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-19 00:00:00 | [NAME] | 252 - Kay Rd Cutdown | 08-Other | 2 |  |  | 253 - 116 Kay Rd Subdivision | 05-Water
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-08-20 00:00:00 | Jury [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading | 7 |  |  | 253 - 116 Kay Rd Subdivision | 06-Concrete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 07-Environmental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 08-Variation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 09-Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 10-Meeting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 11-Management (On-site)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 12-Management (Off-site)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 - 116 Kay Rd Subdivision | 13-Survey