Spreadsheet: 827963d1683149631-how-to-split-multiple-columns-into-multiple-rows-with-separate-groups-of-columns-intervention-database-example-form-and-data-tables
Sheet: Sheet1

Microsoft Form possible response format
District | School | School Year | Intervention 1 Name | Intervention Type 1 | Subject 1 | [NAME] (1) | [NAME]) 1 | Intervention 2 Name | Intervention Type 2 | Subject 2 | [NAME] (2) | [NAME]) 2 | Intervention 3 Name | Intervention Type 3 | Subject 3 | [NAME] (3) | [NAME]) 3 |  | Limit of 15 Interventions per form
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | K; 1st; 2nd; 3rd; 4th; 5th | [NAME] | Math Intervention Middle | Academic | Math | 6th; 7th; 8th | [NAME]; Tier 3 | Behavior Intervention | Behavior | N/A | 2nd; 3rd; 4th; 5th; 6th; 7th | [NAME]
District B | School B | 2022-2023 | Math Intervention Elementary | Academic | Math | 2nd; 3rd | [NAME] | Math Intervention Fractions | Academic | Math | 5th | Tier 3
Data Table Example 1 (Multi-selection values in same row and column) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Which districts are using Math Intervention Elementary?
District | School | School Year | [NAME] | Intervention Type | Subject | [NAME] | [NAME]) |  |  |  |  |  |  |  |  |  |  | District | School | School Year | [NAME] | Intervention Type | Subject | [NAME] | [NAME])
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | K; 1st; 2nd; 3rd; 4th; 5th | [NAME] |  |  |  |  |  |  |  |  |  |  | District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | K; 1st; 2nd; 3rd; 4th; 5th | [NAME]
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 6th; 7th; 8th | [NAME]; Tier 3 |  |  |  |  |  |  |  |  |  |  | District B | School B | 2022-2023 | Math Intervention Elementary | Academic | Math | 2nd; 3rd | [NAME]
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 2nd; 3rd; 4th; 5th; 6th; 7th | [NAME]
District B | School B | 2022-2023 | Math Intervention Elementary | Academic | Math | 2nd; 3rd | [NAME]
District B | School B | 2022-2023 | Math Intervention Fractions | Academic | Math | 5th | Tier 3 |  |  |  |  |  |  |  |  |  |  | What interventions are districts using in Math in Grades K-5th?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | District | School | School Year | [NAME] | Intervention Type | Subject | [NAME] | [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | K; 1st; 2nd; 3rd; 4th; 5th | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | District B | School B | 2022-2023 | Math Intervention Elementary | Academic | Math | 2nd; 3rd | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | District B | School B | 2022-2023 | Math Intervention Fractions | Academic | Math | 5th | Tier 3
Data Table Example 2 (Multi-selection values in separate rows)
District | School | School Year | [NAME] | Intervention Type | Subject | [NAME] | [NAME])
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | K | [NAME] |  |  |  |  |  |  |  |  |  |  | What [NAME] or Tier 3 Math interventions are districts using, and for which [NAME]? /  What Math interventions are districts using at Tier 2 or Tier 3 and how many?
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | 1st | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | District | K | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | 2nd | [NAME] |  |  |  |  |  |  |  |  |  |  | Math Intervention Elementary | 2 | 1 | 1 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | 3rd | [NAME] |  |  |  |  |  |  |  |  |  |  | Math Intervention Fractions | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | 4th | [NAME]
District A | School A | 2022-2023 | Math Intervention Elementary | Academic | Math | 5th | [NAME]
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 6th | [NAME]
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 7th | [NAME]
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 8th | [NAME]
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 6th | Tier 3
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 7th | Tier 3
District A | School A | 2022-2023 | Math Intervention Middle | Academic | Math | 8th | Tier 3
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 2nd | [NAME]
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 3rd | [NAME]
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 4th | [NAME]
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 5th | [NAME]
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 6th | [NAME]
District A | School A | 2022-2023 | Behavior Intervention | Behavior | N/A | 7th | [NAME]
District B | School B | 2022-2023 | Math Intervention Elementary | Academic | Math | 2nd | [NAME]
District B | School B | 2022-2023 | Math Intervention Elementary | Academic | Math | 3rd | [NAME]
District B | School B | 2022-2023 | Math Intervention Fractions | Academic | Math | 5th | Tier 3