Spreadsheet: 118384d1313649036-matching-pivot
Sheet: Sheet1

Date | Last Name | Location |  | Note: data in column E & F is obtained through remove duplicate command |  |  |  | Row Labels | Location | Count of Date | Pivot is not apply on orignal sheet due to some unknown issue
2011-07-18 00:00:00 | [NAME] | Alaska |  | [NAME] | Alaska | 2 |  | BRANDON HILL | California | 2
2011-07-18 00:00:00 | [NAME] | Georgia |  | [NAME] | Georgia | 1 |  | BRENNAN STEPHANIE A | (blank) | 1
2011-07-18 00:00:00 | KHAMSOUK ARAHATE | Colorado |  | KHAMSOUK ARAHATE | Colorado | 1 |  | BRITTANNY NOELLE | (blank) | 3
2011-07-18 00:00:00 | MONTGOMERY ANDRE | Colorado |  | MONTGOMERY ANDRE | Colorado | 1 |  | [NAME] | (blank) | 2
2011-07-18 00:00:00 | SCOTT CARLTON | New York |  | SCOTT CARLTON | New York | 1 |  | FITZPATRICK [NAME] | (blank) | 2
2011-07-18 00:00:00 | [NAME] | California |  | [NAME] | California | 1 |  | [NAME] | (blank) | 2
2011-07-18 00:00:00 | [NAME] | Florida |  | [NAME] | Florida | 1 |  | [NAME] | (blank) | 2
2011-07-19 00:00:00 | [NAME] | New Mexico |  | [NAME] | New Mexico | 1 |  | JEREMY [NAME] | (blank) | 1
2011-07-19 00:00:00 | BRANDON HILL | California |  | BRANDON HILL | California | 2 |  | [NAME] | Alaska | 2
2011-07-20 00:00:00 | MONTGOMERY ANDRE | Missouri |  | MONTGOMERY ANDRE | Missouri | 1 |  |  | Florida | 1
2011-07-20 00:00:00 | [NAME] | Alaska |  | [NAME] |  | 2 |  | [NAME] | California | 1
2011-07-20 00:00:00 | [NAME] |  |  | JUSTIN SPENCER |  | 2 |  | JUSTIN RYAN | (blank) | 2
2011-07-20 00:00:00 | JUSTIN SPENCER |  |  | [NAME] |  | 2 |  | JUSTIN SPENCER | (blank) | 2
2011-07-20 00:00:00 | [NAME] |  |  | [NAME] |  | 2 |  | KHAMSOUK ARAHATE | Colorado | 1
2011-07-20 00:00:00 | [NAME] |  |  | LYNCH JAMES |  | 1 |  | LYNCH JAMES | (blank) | 1
2011-08-10 00:00:00 | LYNCH JAMES |  |  | MARKWOOD CHRISTOPHER M |  | 1 |  | MARKWOOD CHRISTOPHER M | (blank) | 1
2011-07-25 00:00:00 | MARKWOOD CHRISTOPHER M |  |  | BRENNAN STEPHANIE A |  | 1 |  | MCCARTY STEPHEN | (blank) | 3
2011-07-25 00:00:00 | BRENNAN STEPHANIE A |  |  | FITZPATRICK [NAME] |  | 2 |  | MEEHAN LYNN | (blank) | 1
2011-07-25 00:00:00 | BRANDON HILL | California |  | SCHULTZ ERIC E |  | 2 |  | MONTGOMERY ANDRE | Colorado | 1
2011-07-25 00:00:00 | FITZPATRICK [NAME] |  |  | MCCARTY STEPHEN |  | 3 |  |  | Missouri | 1
2011-07-25 00:00:00 | SCHULTZ ERIC E |  |  | TYRONE LOVETTE |  | 3 |  | RYAN EDWIN | (blank) | 1
2011-07-25 00:00:00 | MCCARTY STEPHEN |  |  | TROY DELACY |  | 2 |  | SCHULTZ ERIC E | (blank) | 2
2011-07-25 00:00:00 | TYRONE LOVETTE |  |  | RYAN EDWIN |  | 1 |  | SCOTT CARLTON | New York | 1
2011-07-25 00:00:00 | TROY DELACY |  |  | JUSTIN RYAN |  | 2 |  | [NAME] | Georgia | 1
2011-07-25 00:00:00 | RYAN EDWIN |  |  | JEREMY [NAME] |  | 1 |  |  | New Mexico | 1
2011-07-26 00:00:00 | JUSTIN RYAN |  |  | BRITTANNY NOELLE |  | 3 |  | TROY DELACY | (blank) | 2
2011-07-26 00:00:00 | JUSTIN RYAN |  |  | MEEHAN LYNN |  | 1 |  | TYRONE LOVETTE | (blank) | 3
2011-07-26 00:00:00 | JEREMY [NAME] |  |  |  |  |  |  | Grand Total |  | 43
2011-07-26 00:00:00 | MCCARTY STEPHEN
2011-07-27 00:00:00 | TYRONE LOVETTE
2011-07-27 00:00:00 | BRITTANNY NOELLE
2011-07-27 00:00:00 | BRITTANNY NOELLE
2011-07-27 00:00:00 | BRITTANNY NOELLE
2011-08-04 00:00:00 | MEEHAN LYNN
2011-08-04 00:00:00 | [NAME]
2011-08-08 00:00:00 | JUSTIN SPENCER
2011-08-08 00:00:00 | [NAME]
2011-08-08 00:00:00 | [NAME]
2011-08-08 00:00:00 | FITZPATRICK [NAME]
2011-08-08 00:00:00 | SCHULTZ ERIC E
2011-08-08 00:00:00 | MCCARTY STEPHEN
2011-08-09 00:00:00 | TYRONE LOVETTE
2011-08-09 00:00:00 | TROY DELACY