Spreadsheet: 376007d1423451356-taking-multiple-excel-documents-and-grouping-the-data-into-a-single-spreadsheet-apollo-ver2
Sheet: Data

Name | Date Taken | # | Guest Name | Date | # Of Guests | Service Provided | Res. ID | Add-On Detail | Revised | *Payments /POA | **Sent
Vince | 2015-01-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 4 | Tram | 24263819 | - | - | 43 | E
Vince | 2015-01-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 2 | Tram | 24263845 | - | - | 17 | D
Vince | 2015-01-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 5 | Tram | 24264127 | - | - | 43 | E
Vince | 2015-01-07 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 | 2 | Tram | 24264460 | - | - | 23 | E
Vince | 2015-01-06 00:00:00 | 1 | [NAME] | 2015-10-22 00:00:00 | 50 | Kimmswick | 24263430 | Final: 10/8/15 | - | - | E
Vince | 2015-01-06 00:00:00 | 1 | [NAME] | 2015-08-06 00:00:00 | 2 | Tram | 24263444 | - | - | 17 | E
Vince | 2015-01-06 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 | 2 | Tram | 24262376 | - | Changed time | - | D
Vince | 2015-01-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 2 | Tram | 24263573 | - | - | 23 | E
Vince | 2015-01-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 18 | Tram | 24263309 | - | Changed time | - | D
Vince | 2015-01-05 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 | 5 | Tram | 24262904 | - | Changed time | - | D
Vince | 2015-01-05 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 | 7 | Tram | 24262927 | - | - | 48 | E
Vince | 2015-01-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 | 34 | Tram | 24262934 | Final: 5/6/15 | - | - | E
Vince | 2015-01-05 00:00:00 | 1 | Red Lake | 2015-03-26 00:00:00 | 90 | Capt/Box/OCH | 24262576 | Final: 3/12/15 | Changed times | - | E
Vince | 2015-01-05 00:00:00 | 1 | Lebanon | 2015-05-08 00:00:00 | 39 | SS | 24263002 | Final: 4/24/15 | - | - | E
Vince | 2015-01-05 00:00:00 | 1 | [NAME] | 2015-04-16 00:00:00 | 69 | Tram | 24263011 | Final: 4/2/15 | - | - | E
Vince | 2015-01-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 | 43 | Tram | 24263043 | Final: 5/6/15 | - | - | E
Vince | 2015-01-02 00:00:00 | 1 | [NAME] | 2015-08-10 00:00:00 | 6 | LAW | 24262441 | - | - | 0 | E
Vince | 2015-01-02 00:00:00 | 1 | [NAME] | 2015-04-29 00:00:00 | 71 | Tram | 24262458 | Final: 4/15/15 | - | - | E
Vince | 2015-01-02 00:00:00 | 1 | Rogers High School | 2015-05-01 00:00:00 | 204 | Tram | 24262583 | Final: 4/17/15 | - | - | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263819 | - | - | 43 | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263845 | - | - | 17 | D
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24264127 | - | - | 43 | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 |  | Tram | 24264460 | - | - | 23 | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-10-22 00:00:00 |  | Kimmswick | 24263430 | Final: 10/8/15 | - | - | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-08-06 00:00:00 |  | Tram | 24263444 | - | - | 17 | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 |  | Tram | 24262376 | - | Changed time | - | D
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263573 | - | - | 23 | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263309 | - | Changed time | - | D
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 |  | Tram | 24262904 | - | Changed time | - | D
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 |  | Tram | 24262927 | - | - | 48 | E
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 |  | Tram | 24262934 | Final: 5/6/15 | - | - | E
Vince | 2015-02-05 00:00:00 | 1 | Red Lake | 2015-03-26 00:00:00 |  | Capt/Box/OCH | 24262576 | Final: 3/12/15 | Changed times | - | E
Vince | 2015-02-05 00:00:00 | 1 | Lebanon | 2015-05-08 00:00:00 |  | SS | 24263002 | Final: 4/24/15 | - | - | E
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-04-16 00:00:00 |  | Tram | 24263011 | Final: 4/2/15 | - | - | E
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 |  | Tram | 24263043 | Final: 5/6/15 | - | - | E
Vince | 2015-02-02 00:00:00 | 1 | [NAME] | 2015-08-10 00:00:00 |  | LAW | 24262441 | - | - | 0 | E
Vince | 2015-02-02 00:00:00 | 1 | [NAME] | 2015-04-29 00:00:00 |  | Tram | 24262458 | Final: 4/15/15 | - | - | E
Vince | 2015-02-02 00:00:00 | 1 | Rogers High School | 2015-05-01 00:00:00 |  | Tram | 24262583 | Final: 4/17/15 | - | - | E
Vince | 2015-03-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263819 | - | - | 43 | E
Vince | 2015-03-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263845 | - | - | 17 | D
Vince | 2015-03-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24264127 | - | - | 43 | E
Vince | 2015-03-07 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 |  | Tram | 24264460 | - | - | 23 | E
Vince | 2015-03-06 00:00:00 | 1 | [NAME] | 2015-10-22 00:00:00 |  | Kimmswick | 24263430 | Final: 10/8/15 | - | - | E
Vince | 2015-03-06 00:00:00 | 1 | [NAME] | 2015-08-06 00:00:00 |  | Tram | 24263444 | - | - | 17 | E
Vince | 2015-03-06 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 |  | Tram | 24262376 | - | Changed time | - | D
Vince | 2015-03-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263573 | - | - | 23 | E
Vince | 2015-03-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 |  | Tram | 24263309 | - | Changed time | - | D
Vince | 2015-03-05 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 |  | Tram | 24262904 | - | Changed time | - | D
Vince | 2015-03-05 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 |  | Tram | 24262927 | - | - | 48 | E
Vince | 2015-03-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 |  | Tram | 24262934 | Final: 5/6/15 | - | - | E
Vince | 2015-03-05 00:00:00 | 1 | Red Lake | 2015-03-26 00:00:00 |  | Capt/Box/OCH | 24262576 | Final: 3/12/15 | Changed times | - | E
Vince | 2015-03-05 00:00:00 | 1 | Lebanon | 2015-05-08 00:00:00 |  | SS | 24263002 | Final: 4/24/15 | - | - | E
Vince | 2015-03-05 00:00:00 | 1 | [NAME] | 2015-04-16 00:00:00 |  | Tram | 24263011 | Final: 4/2/15 | - | - | E
Vince | 2015-03-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 |  | Tram | 24263043 | Final: 5/6/15 | - | - | E
Vince | 2015-03-02 00:00:00 | 1 | [NAME] | 2015-08-10 00:00:00 |  | LAW | 24262441 | - | - | 0 | E
Vince | 2015-03-02 00:00:00 | 1 | [NAME] | 2015-04-29 00:00:00 |  | Tram | 24262458 | Final: 4/15/15 | - | - | E
Vince | 2015-03-02 00:00:00 | 1 | Rogers High School | 2015-05-01 00:00:00 |  | Tram | 24262583 | Final: 4/17/15 | - | - | E