Reputation: 3
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.
Upvotes: 0
Views: 178
Reputation: 815
Since you have Excel 2016, you have more options than ever.
You might use PowerQuery to get data from other workbooks or tables in the same workbok. Add a year column (sheetname in my case to simulate) to each file or table or whatever.
You could then append the queries to each other
Resulting in a list with the year (or in my case sheetname) added in.
You could pivot the resulting data
And then chart
Upvotes: 1