ABCDEFG
1
2020 AprilINDIRECT("2020 April!A:C")IFERROR(INDIRECT("2020 April!A:C"), {"","",""}){IFERROR(INDIRECT("2020 April!A:C"), {"","",""}); IFERROR(INDIRECT("2020 May!A:C"), {"","",""}); IFERROR(INDIRECT("2020 June!A:C"), {"","",""}); IFERROR(INDIRECT("2020 July!A:C"), {"","",""}); IFERROR(INDIRECT("2020 August!A:C"), {"","",""}); IFERROR(INDIRECT("2020 September!A:C"), {"","",""}); IFERROR(INDIRECT("2020 October!A:C"), {"","",""}); IFERROR(INDIRECT("2020 November!A:C"), {"","",""}); IFERROR(INDIRECT("2020 December!A:C"), {"","",""}); IFERROR(INDIRECT("2021 January!A:C"), {"","",""}); IFERROR(INDIRECT("2021 February!A:C"), {"","",""}); IFERROR(INDIRECT("2021 March!A:C"), {"","",""}); IFERROR(INDIRECT("2021 April!A:C"), {"","",""}); IFERROR(INDIRECT("2021 May!A:C"), {"","",""}); IFERROR(INDIRECT("2021 June!A:C"), {"","",""}); IFERROR(INDIRECT("2021 July!A:C"), {"","",""}); IFERROR(INDIRECT("2021 August!A:C"), {"","",""}); IFERROR(INDIRECT("2021 September!A:C"), {"","",""}); IFERROR(INDIRECT("2021 October!A:C"), {"","",""}); IFERROR(INDIRECT("2021 November!A:C"), {"","",""}); IFERROR(INDIRECT("2021 December!A:C"), {"","",""}); IFERROR(INDIRECT("2022 January!A:C"), {"","",""}); IFERROR(INDIRECT("2022 February!A:C"), {"","",""}); IFERROR(INDIRECT("2022 March!A:C"), {"","",""}); IFERROR(INDIRECT("2022 April!A:C"), {"","",""}); IFERROR(INDIRECT("2022 May!A:C"), {"","",""}); IFERROR(INDIRECT("2022 June!A:C"), {"","",""}); IFERROR(INDIRECT("2022 July!A:C"), {"","",""}); IFERROR(INDIRECT("2022 August!A:C"), {"","",""}); IFERROR(INDIRECT("2022 September!A:C"), {"","",""}); IFERROR(INDIRECT("2022 October!A:C"), {"","",""}); IFERROR(INDIRECT("2022 November!A:C"), {"","",""}); IFERROR(INDIRECT("2022 December!A:C"), {"","",""}); IFERROR(INDIRECT("2023 January!A:C"), {"","",""}); IFERROR(INDIRECT("2023 February!A:C"), {"","",""}); IFERROR(INDIRECT("2023 March!A:C"), {"","",""}); IFERROR(INDIRECT("2023 April!A:C"), {"","",""}); IFERROR(INDIRECT("2023 May!A:C"), {"","",""}); IFERROR(INDIRECT("2023 June!A:C"), {"","",""}); IFERROR(INDIRECT("2023 July!A:C"), {"","",""}); IFERROR(INDIRECT("2023 August!A:C"), {"","",""}); IFERROR(INDIRECT("2023 September!A:C"), {"","",""}); IFERROR(INDIRECT("2023 October!A:C"), {"","",""}); IFERROR(INDIRECT("2023 November!A:C"), {"","",""}); IFERROR(INDIRECT("2023 December!A:C"), {"","",""}); IFERROR(INDIRECT("2024 January!A:C"), {"","",""}); IFERROR(INDIRECT("2024 February!A:C"), {"","",""}); IFERROR(INDIRECT("2024 March!A:C"), {"","",""}); IFERROR(INDIRECT("2024 April!A:C"), {"","",""}); IFERROR(INDIRECT("2024 May!A:C"), {"","",""}); IFERROR(INDIRECT("2024 June!A:C"), {"","",""}); IFERROR(INDIRECT("2024 July!A:C"), {"","",""}); IFERROR(INDIRECT("2024 August!A:C"), {"","",""})}
2
2020 MayINDIRECT("2020 May!A:C")IFERROR(INDIRECT("2020 May!A:C"), {"","",""})=QUERY({IFERROR(INDIRECT("2020 April!A:C"), {"","",""}); IFERROR(INDIRECT("2020 May!A:C"), {"","",""}); IFERROR(INDIRECT("2020 June!A:C"), {"","",""}); IFERROR(INDIRECT("2020 July!A:C"), {"","",""}); IFERROR(INDIRECT("2020 August!A:C"), {"","",""}); IFERROR(INDIRECT("2020 September!A:C"), {"","",""}); IFERROR(INDIRECT("2020 October!A:C"), {"","",""}); IFERROR(INDIRECT("2020 November!A:C"), {"","",""}); IFERROR(INDIRECT("2020 December!A:C"), {"","",""}); IFERROR(INDIRECT("2021 January!A:C"), {"","",""}); IFERROR(INDIRECT("2021 February!A:C"), {"","",""}); IFERROR(INDIRECT("2021 March!A:C"), {"","",""}); IFERROR(INDIRECT("2021 April!A:C"), {"","",""}); IFERROR(INDIRECT("2021 May!A:C"), {"","",""}); IFERROR(INDIRECT("2021 June!A:C"), {"","",""}); IFERROR(INDIRECT("2021 July!A:C"), {"","",""}); IFERROR(INDIRECT("2021 August!A:C"), {"","",""}); IFERROR(INDIRECT("2021 September!A:C"), {"","",""}); IFERROR(INDIRECT("2021 October!A:C"), {"","",""}); IFERROR(INDIRECT("2021 November!A:C"), {"","",""}); IFERROR(INDIRECT("2021 December!A:C"), {"","",""}); IFERROR(INDIRECT("2022 January!A:C"), {"","",""}); IFERROR(INDIRECT("2022 February!A:C"), {"","",""}); IFERROR(INDIRECT("2022 March!A:C"), {"","",""}); IFERROR(INDIRECT("2022 April!A:C"), {"","",""}); IFERROR(INDIRECT("2022 May!A:C"), {"","",""}); IFERROR(INDIRECT("2022 June!A:C"), {"","",""}); IFERROR(INDIRECT("2022 July!A:C"), {"","",""}); IFERROR(INDIRECT("2022 August!A:C"), {"","",""}); IFERROR(INDIRECT("2022 September!A:C"), {"","",""}); IFERROR(INDIRECT("2022 October!A:C"), {"","",""}); IFERROR(INDIRECT("2022 November!A:C"), {"","",""}); IFERROR(INDIRECT("2022 December!A:C"), {"","",""}); IFERROR(INDIRECT("2023 January!A:C"), {"","",""}); IFERROR(INDIRECT("2023 February!A:C"), {"","",""}); IFERROR(INDIRECT("2023 March!A:C"), {"","",""}); IFERROR(INDIRECT("2023 April!A:C"), {"","",""}); IFERROR(INDIRECT("2023 May!A:C"), {"","",""}); IFERROR(INDIRECT("2023 June!A:C"), {"","",""}); IFERROR(INDIRECT("2023 July!A:C"), {"","",""}); IFERROR(INDIRECT("2023 August!A:C"), {"","",""}); IFERROR(INDIRECT("2023 September!A:C"), {"","",""}); IFERROR(INDIRECT("2023 October!A:C"), {"","",""}); IFERROR(INDIRECT("2023 November!A:C"), {"","",""}); IFERROR(INDIRECT("2023 December!A:C"), {"","",""}); IFERROR(INDIRECT("2024 January!A:C"), {"","",""}); IFERROR(INDIRECT("2024 February!A:C"), {"","",""}); IFERROR(INDIRECT("2024 March!A:C"), {"","",""}); IFERROR(INDIRECT("2024 April!A:C"), {"","",""}); IFERROR(INDIRECT("2024 May!A:C"), {"","",""}); IFERROR(INDIRECT("2024 June!A:C"), {"","",""}); IFERROR(INDIRECT("2024 July!A:C"), {"","",""}); IFERROR(INDIRECT("2024 August!A:C"), {"","",""})}, "select Col1,Col2 where Col3 is not null", 0)
3
2020 JuneINDIRECT("2020 June!A:C")IFERROR(INDIRECT("2020 June!A:C"), {"","",""})
4
2020 JulyINDIRECT("2020 July!A:C")IFERROR(INDIRECT("2020 July!A:C"), {"","",""})
5
2020 AugustINDIRECT("2020 August!A:C")IFERROR(INDIRECT("2020 August!A:C"), {"","",""})
6
2020 SeptemberINDIRECT("2020 September!A:C")IFERROR(INDIRECT("2020 September!A:C"), {"","",""})
7
2020 OctoberINDIRECT("2020 October!A:C")IFERROR(INDIRECT("2020 October!A:C"), {"","",""})
8
2020 NovemberINDIRECT("2020 November!A:C")IFERROR(INDIRECT("2020 November!A:C"), {"","",""})
9
2020 DecemberINDIRECT("2020 December!A:C")IFERROR(INDIRECT("2020 December!A:C"), {"","",""})
10
2021 JanuaryINDIRECT("2021 January!A:C")IFERROR(INDIRECT("2021 January!A:C"), {"","",""})
11
2021 FebruaryINDIRECT("2021 February!A:C")IFERROR(INDIRECT("2021 February!A:C"), {"","",""})
12
2021 MarchINDIRECT("2021 March!A:C")IFERROR(INDIRECT("2021 March!A:C"), {"","",""})
13
2021 AprilINDIRECT("2021 April!A:C")IFERROR(INDIRECT("2021 April!A:C"), {"","",""})
14
2021 MayINDIRECT("2021 May!A:C")IFERROR(INDIRECT("2021 May!A:C"), {"","",""})
15
2021 JuneINDIRECT("2021 June!A:C")IFERROR(INDIRECT("2021 June!A:C"), {"","",""})
16
2021 JulyINDIRECT("2021 July!A:C")IFERROR(INDIRECT("2021 July!A:C"), {"","",""})
17
2021 AugustINDIRECT("2021 August!A:C")IFERROR(INDIRECT("2021 August!A:C"), {"","",""})
18
2021 SeptemberINDIRECT("2021 September!A:C")IFERROR(INDIRECT("2021 September!A:C"), {"","",""})
19
2021 OctoberINDIRECT("2021 October!A:C")IFERROR(INDIRECT("2021 October!A:C"), {"","",""})
20
2021 NovemberINDIRECT("2021 November!A:C")IFERROR(INDIRECT("2021 November!A:C"), {"","",""})
21
2021 DecemberINDIRECT("2021 December!A:C")IFERROR(INDIRECT("2021 December!A:C"), {"","",""})
22
2022 JanuaryINDIRECT("2022 January!A:C")IFERROR(INDIRECT("2022 January!A:C"), {"","",""})
23
2022 FebruaryINDIRECT("2022 February!A:C")IFERROR(INDIRECT("2022 February!A:C"), {"","",""})
24
2022 MarchINDIRECT("2022 March!A:C")IFERROR(INDIRECT("2022 March!A:C"), {"","",""})
25
2022 AprilINDIRECT("2022 April!A:C")IFERROR(INDIRECT("2022 April!A:C"), {"","",""})
26
2022 MayINDIRECT("2022 May!A:C")IFERROR(INDIRECT("2022 May!A:C"), {"","",""})
27
2022 JuneINDIRECT("2022 June!A:C")IFERROR(INDIRECT("2022 June!A:C"), {"","",""})
28
2022 JulyINDIRECT("2022 July!A:C")IFERROR(INDIRECT("2022 July!A:C"), {"","",""})
29
2022 AugustINDIRECT("2022 August!A:C")IFERROR(INDIRECT("2022 August!A:C"), {"","",""})
30
2022 SeptemberINDIRECT("2022 September!A:C")IFERROR(INDIRECT("2022 September!A:C"), {"","",""})
31
2022 OctoberINDIRECT("2022 October!A:C")IFERROR(INDIRECT("2022 October!A:C"), {"","",""})
32
2022 NovemberINDIRECT("2022 November!A:C")IFERROR(INDIRECT("2022 November!A:C"), {"","",""})
33
2022 DecemberINDIRECT("2022 December!A:C")IFERROR(INDIRECT("2022 December!A:C"), {"","",""})
34
2023 JanuaryINDIRECT("2023 January!A:C")IFERROR(INDIRECT("2023 January!A:C"), {"","",""})
35
2023 FebruaryINDIRECT("2023 February!A:C")IFERROR(INDIRECT("2023 February!A:C"), {"","",""})
36
2023 MarchINDIRECT("2023 March!A:C")IFERROR(INDIRECT("2023 March!A:C"), {"","",""})
37
2023 AprilINDIRECT("2023 April!A:C")IFERROR(INDIRECT("2023 April!A:C"), {"","",""})
38
2023 MayINDIRECT("2023 May!A:C")IFERROR(INDIRECT("2023 May!A:C"), {"","",""})
39
2023 JuneINDIRECT("2023 June!A:C")IFERROR(INDIRECT("2023 June!A:C"), {"","",""})
40
2023 JulyINDIRECT("2023 July!A:C")IFERROR(INDIRECT("2023 July!A:C"), {"","",""})
41
2023 AugustINDIRECT("2023 August!A:C")IFERROR(INDIRECT("2023 August!A:C"), {"","",""})
42
2023 SeptemberINDIRECT("2023 September!A:C")IFERROR(INDIRECT("2023 September!A:C"), {"","",""})
43
2023 OctoberINDIRECT("2023 October!A:C")IFERROR(INDIRECT("2023 October!A:C"), {"","",""})
44
2023 NovemberINDIRECT("2023 November!A:C")IFERROR(INDIRECT("2023 November!A:C"), {"","",""})
45
2023 DecemberINDIRECT("2023 December!A:C")IFERROR(INDIRECT("2023 December!A:C"), {"","",""})
46
2024 JanuaryINDIRECT("2024 January!A:C")IFERROR(INDIRECT("2024 January!A:C"), {"","",""})
47
2024 FebruaryINDIRECT("2024 February!A:C")IFERROR(INDIRECT("2024 February!A:C"), {"","",""})
48
2024 MarchINDIRECT("2024 March!A:C")IFERROR(INDIRECT("2024 March!A:C"), {"","",""})
49
2024 AprilINDIRECT("2024 April!A:C")IFERROR(INDIRECT("2024 April!A:C"), {"","",""})
50
2024 MayINDIRECT("2024 May!A:C")IFERROR(INDIRECT("2024 May!A:C"), {"","",""})
51
2024 JuneINDIRECT("2024 June!A:C")IFERROR(INDIRECT("2024 June!A:C"), {"","",""})
52
2024 JulyINDIRECT("2024 July!A:C")IFERROR(INDIRECT("2024 July!A:C"), {"","",""})
53
2024 AugustINDIRECT("2024 August!A:C")IFERROR(INDIRECT("2024 August!A:C"), {"","",""})
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100