Spreadsheet: 853232d1703128967-combining-data-from-multiple-sheets-vstack-etc-stack-example
Sheet: Sheet1

 |  | Consolidated |  |  |  |  |  |  |  | 2022 |  |  |  | 2023
EXAMPLE 1 |  | Name | Party | Badge # |  |  |  |  |  | Name | Party | Badge # |  | Name | Party | Badge #
 |  |  | Independent | 11 |  |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent | 11
 |  | [NAME] | Democrat | 15 |  |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat | 15
 |  | [NAME] | Independent | 18 |  |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican | 19
 |  | [NAME] | Republican | 19 |  |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican | 22
 |  | [NAME] | Independent | 20 |  |  |  |  |  |  |  |  |  | [NAME] | Independent | 20
 |  | [NAME] | Republican | 22
 |  | [NAME] | Republican | 31
 |  | [NAME] | Democrat | 45
 |  | Consolidated |  |  |  |  |  |  |  | 2022 |  |  |  | 2023
EXAMPLE 2 |  | Name | Party | Badge # |  |  |  |  |  | Name | Party | Badge # |  | Name | Party | Badge #
 |  |  | Democrat | 45 |  |  | Democrat | 0 |  | [NAME] | Democrat | 45 |  | [NAME] | Independent
 |  | [NAME] | Republican | 22 |  | [NAME] | Republican | 31 |  | [NAME] | Republican | 22 |  | [NAME] | Democrat
 |  | [NAME] | Independent | 18 |  | [NAME] | Republican | 22 |  | [NAME] | Independent | 18 |  | [NAME] | Republican
 |  | [NAME] | Republican | 31 |  | [NAME] | Democrat | 45 |  | [NAME] | Republican | 31 |  | [NAME] | Republican
 |  | [NAME] | Independent | 0 |  | [NAME] | Independent | 18 |  |  |  |  |  | [NAME] | Independent
 |  | [NAME] | Democrat | 0 |  | [NAME] | Republican | 0
 |  | [NAME] | Republican | 0 |  | [NAME] | Independent | 0
 |  | [NAME] | Republican | 0 |  | [NAME] | Independent | 0
 |  | [NAME] | Independent | 0
 |  | Consolidated |  |  |  |  |  |  |  | 2022 |  |  |  | 2023
EXAMPLE 3 |  | Name | Party | Badge # | Committee Room |  |  |  |  | Name | Party | Badge # |  | Name | Party | Committee Room
 |  |  | Democrat | 45 |  |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent | A10
 |  | [NAME] | Republican | 22 |  |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat | B25
 |  | [NAME] | Independent | 18 |  |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican | A10
 |  | [NAME] | Republican | 31 |  |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican | A15
 |  | [NAME] | Independent | A10 |  |  |  |  |  |  |  |  |  | [NAME] | Independent | C12
 |  | [NAME] | Democrat | B25
 |  | [NAME] | Republican | A10
 |  | [NAME] | Republican | A15
 |  | [NAME] | Independent | C12
EXAMPLE 4 |  | Consolidated |  |  |  |  |  |  |  | 2022 |  |  |  | 2023
 |  | Name | Party | Badge # | Committee Room |  |  |  |  | Name | Party | Badge # |  | Name | Party | Committee Room
 |  |  |  |  |  |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent | A10
 |  | [NAME] |  |  |  |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat | B25
 |  | [NAME] |  |  |  |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican | A10
 |  | [NAME] |  |  |  |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican | A15
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Independent | C12
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  |  | Democrat |  | B25
 |  | [NAME] | Republican | 31
 |  | [NAME] | Republican | 22 | A15
 |  | [NAME] | Democrat | 45
 |  | [NAME] | Independent | 18
 |  | [NAME] | Republican |  | A10
 |  | [NAME] | Independent |  | C12
 |  | [NAME] | Independent |  | A10