Spreadsheet: 38162d1236277780-formatting-data-mess
Sheet: Sheet1

LAST | FIRST | AL | AK | AZ | AR | CA | CO | CT | DE | FL | GA | HI | ID | IL | IN | IA | KS | KY | LA | ME | MD | MA | MI | MN | MS | MO | MT | NE | NV | NH | NJ | NM | NY | NC | ND | OH | OK | OR | PA | RI | SC | SD | TN | TX | UT | VT | VA | WA | WV | WI | WY
[NAME] | [NAME] |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  | N | 1 |  |  | 1 |  | 1 | N | 1 | 1 |  | N |  | 1 |  |  | 1 |  | 1 |  | 1 |  | 1 | 1 |  |  | N |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | N |  | 1
[NAME] | [NAME] |  |  | 1 | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 | 1 |  |  |  |  | 1 |  |  |  |  | 1 | 1 |  | 1 | 1
Cole | [NAME] |  |  |  |  | 1 |  | N |  |  |  | N |  |  |  |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  |  |  |  |  | N |  | N | N
Harrell | [NAME] |  |  |  |  | 1 |  | N |  |  |  | N |  |  |  |  |  |  | N |  |  | 1 | N |  |  |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  |  |  |  |  | N |  | 1 | N
Jimenez | Cecile | N | N |  |  | 1 |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  | P |  |  |  | N |  |  |  |  |  |  |  |  |  | N | N |  |  |  |  |  |  |  |  |  | N |  |  | N
[NAME] | [NAME] |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  | N | 1 |  |  | 1 |  | 1 | N | 1 | 1 |  | N |  | 1 | P |  | 1 |  | 1 |  | 1 |  | 1 | 1 |  |  | N |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | N |  | 1
Librizzo | Sandy | N | N |  |  | 1 |  |  |  |  | 1 | N |  |  |  |  | N |  | N |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  |  |  | N | N |  |  |  |  |  |  |  |  |  | N |  |  | N
[NAME] | [NAME] |  |  | P | P | 1 | 1 |  |  | P | 1 | N |  | 1 |  |  |  |  | N |  |  |  | N | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | N | P |  |  |  |  | P | P |  | 1 | 1
Lyon | [NAME] | N | N |  |  | 1 |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  |  |  | N | N |  |  |  |  |  |  |  |  |  | N |  |  | N
[NAME] | [NAME] | N | N | 1 |  | 1 |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  |  |  | N | N |  |  |  |  |  |  |  |  |  | N |  |  | N
Possel | [NAME] |  |  | 1 | 1 | 1 | 1 |  |  | 1 | 1 | N |  | 0 |  |  |  |  | N |  |  |  | N | 1 |  |  |  |  | 1 |  |  |  | 1 | 1 |  |  |  | N | 1 |  |  |  |  | 1 | 1 |  | 1 | 0
Potter | [NAME] |  |  |  |  | 1 |  | N |  |  |  | N |  |  |  |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  |  |  |  |  | N |  | N | N
Quezada | [NAME] |  |  |  |  | 1 |  | N |  |  |  | N |  |  |  |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  | N |  |  |  |  | N |  | N |  |  |  |  |  |  |  | N |  | N | N
Reeves | Vera |  |  |  |  | 1 |  |  |  |  |  | N |  |  |  |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  | N
Richmond | Roberta |  |  |  |  | 1 |  |  |  |  |  | N |  |  |  |  |  |  | N |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  | N
[NAME] | [NAME] |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 | N | 1 | 1 | 1 | 1 |  | 1 | N | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  | 1 |  | 1 | 1 |  | P | N |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | N |  | 1
Sanchez | [NAME] |  |  | P | P | 1 | P |  |  | P | P |  |  | P |  |  |  |  |  |  |  |  |  | P |  |  |  |  | P |  |  |  | P |  |  |  |  |  | P |  |  |  |  | P | P |  |  | P
Springer | Debbie |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  | N | 1 |  |  | 1 |  | 1 | N | 1 | 1 |  | N |  | 1 |  |  | 1 |  | 1 |  | 1 |  | 1 | 1 |  |  | N |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | N |  | 1
Uneta | Grace |  |  |  |  | 1
Total Licenses per state |  | 0 | 0 | 7 | 6 | 19 | 7 | 0 | 4 | 2 | 5 | 0 | 4 | 3 | 1 | 4 | 0 | 4 | 0 | 4 | 4 | 2 | 1 | 4 | 4 | 1 | 0 | 4 | 4 | 4 | 0 | 4 | 3 | 6 | 4 | 0 | 0 | 0 | 2 | 4 | 4 | 4 | 4 | 6 | 6 | 0 | 7 | 3 | 0 | 4 | 0
N = No
P = Pending
1 = Yes
Team Lead
CO resident
HUB States