I have a bunch of spreadsheets. Each spreadsheet represents one institution. Each spreadsheet contains a list of resources that institution subscribes to.
I want to turn this around so that I end up with one spreadsheet with each resource as column, and each institution that subscribes to that resource underneath it.
Can anyone suggest ways to make this happen?