Billy R
Billy R

Reputation: 3

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:

image

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

Answers (1)

Stephen Lloyd
Stephen Lloyd

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.

enter image description here

You could then append the queries to each other

enter image description here

Resulting in a list with the year (or in my case sheetname) added in.

enter image description here

You could pivot the resulting data

enter image description here

And then chart

enter image description here

enter image description here

Upvotes: 1

Related Questions