'Combining Excel worksheets
Variations on this question have been asked before, but they either don't address my scenario or the answers go over my head.
I'm working on a project using NYC's School Quality Reports. Each year, they put out school-level data that looks like this:
The hitch is that, every year, some schools close and others open. I want each school's data for multiple years in the same spreadsheet, so I can do side-by-side comparisons. I don't want to sum or combine the variables/columns from each year; I just want them to be next to each other.
I'm using Excel 2016.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|