Spreadsheet: 130841d1322612654-adding-zeros-when-not-found-bird_example
Sheet: PIVOT

Sum of number of individuals | Column Labels
Row Labels | 2011-04-24 00:00:00 | 2011-04-29 00:00:00 | 2011-05-04 00:00:00 | 2011-05-06 00:00:00 | 2011-05-07 00:00:00 | 2011-05-15 00:00:00 | Grand Total
AMGO | 1 |  |  | 1 |  |  | 2
119 | 1 |  |  | 1 |  |  | 2
AMRO | 4 | 1 | 1 |  |  |  | 6
119 | 4 | 1 |  |  |  |  | 5
33 |  |  | 1 |  |  |  | 1
BAEA |  |  | 1 |  |  |  | 1
33 |  |  | 1 |  |  |  | 1
BAOR |  |  |  | 2 | 4 | 1 | 7
119 |  |  |  | 2 |  |  | 2
33 |  |  |  |  | 4 | 1 | 5
BAWW |  | 1 |  |  | 1 | 1 | 3
119 |  | 1 |  |  |  |  | 1
33 |  |  |  |  | 1 | 1 | 2
BBWA |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
BCCH | 1 |  |  | 1 |  |  | 2
119 | 1 |  |  | 1 |  |  | 2
BGGN | 2 | 2 | 1 | 1 |  | 1 | 7
119 | 2 | 2 |  | 1 |  |  | 5
33 |  |  | 1 |  |  | 1 | 2
BLBW |  |  |  | 1 |  |  | 1
119 |  |  |  | 1 |  |  | 1
BLJA | 5 | 4 | 1 | 10 | 3 |  | 23
119 | 5 | 4 |  | 10 |  |  | 19
33 |  |  | 1 |  | 3 |  | 4
BRTH | 1 |  |  |  |  |  | 1
119 | 1 |  |  |  |  |  | 1
BTBW |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
BTNW |  |  |  | 2 |  | 1 | 3
119 |  |  |  | 2 |  |  | 2
33 |  |  |  |  |  | 1 | 1
CHSW |  |  |  | 2 |  |  | 2
119 |  |  |  | 2 |  |  | 2
COGR |  |  | 8 |  | 8 |  | 16
33 |  |  | 8 |  | 8 |  | 16
COYE |  |  |  |  | 1 | 1 | 2
33 |  |  |  |  | 1 | 1 | 2
DCCO | 1 |  |  |  | 7 |  | 8
119 | 1 |  |  |  |  |  | 1
33 |  |  |  |  | 7 |  | 7
DOWO | 1 | 2 | 1 | 1 |  |  | 5
119 | 1 | 2 |  | 1 |  |  | 4
33 |  |  | 1 |  |  |  | 1
EAWP |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
EUST |  |  | 6 |  |  |  | 6
33 |  |  | 6 |  |  |  | 6
GBHE | 2 |  |  |  |  |  | 2
119 | 2 |  |  |  |  |  | 2
GRCA |  |  |  | 1 | 1 |  | 2
119 |  |  |  | 1 |  |  | 1
33 |  |  |  |  | 1 |  | 1
HOWR |  |  | 1 | 1 | 1 | 1 | 4
119 |  |  |  | 1 |  |  | 1
33 |  |  | 1 |  | 1 | 1 | 3
MAWA |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
MODO | 1 |  |  |  |  |  | 1
119 | 1 |  |  |  |  |  | 1
MYWA |  | 8 |  | 3 | 7 |  | 18
119 |  | 8 |  | 3 |  |  | 11
33 |  |  |  |  | 7 |  | 7
NOCA | 2 | 1 | 3 | 2 | 1 | 1 | 10
119 | 2 | 1 |  | 2 |  |  | 5
33 |  |  | 3 |  | 1 | 1 | 5
NOFL | 1 |  |  |  |  |  | 1
119 | 1 |  |  |  |  |  | 1
NOPA |  |  |  |  | 1 |  | 1
33 |  |  |  |  | 1 |  | 1
OVEN |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
PAWA |  | 2 |  |  | 1 |  | 3
119 |  | 2 |  |  |  |  | 2
33 |  |  |  |  | 1 |  | 1
RBWO | 2 |  |  | 1 | 1 |  | 4
119 | 2 |  |  | 1 |  |  | 3
33 |  |  |  |  | 1 |  | 1
RCKI |  |  |  |  | 1 |  | 1
33 |  |  |  |  | 1 |  | 1
RTHA |  | 1 |  |  |  |  | 1
119 |  | 1 |  |  |  |  | 1
RWBL | 26 |  | 10 |  | 10 | 6 | 52
119 | 26 |  |  |  |  |  | 26
33 |  |  | 10 |  | 10 | 6 | 26
TEWA |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
TUTI | 1 | 2 |  | 1 |  |  | 4
119 | 1 | 2 |  | 1 |  |  | 4
TUVU |  | 1 |  |  |  |  | 1
119 |  | 1 |  |  |  |  | 1
WAVI |  |  |  |  | 1 |  | 1
33 |  |  |  |  | 1 |  | 1
WBNU |  | 1 |  |  |  |  | 1
119 |  | 1 |  |  |  |  | 1
WODU | 1 |  |  |  |  |  | 1
119 | 1 |  |  |  |  |  | 1
WOTH |  |  |  |  |  | 1 | 1
33 |  |  |  |  |  | 1 | 1
WTSP | 1 |  | 3 |  | 2 |  | 6
119 | 1 |  |  |  |  |  | 1
33 |  |  | 3 |  | 2 |  | 5
YWAR |  |  | 3 |  | 3 | 3 | 9
33 |  |  | 3 |  | 3 | 3 | 9
Grand Total | 53 | 26 | 39 | 30 | 54 | 23 | 225