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?
2 comments
Comments feed for this article
Trackback link
http://access.jiscinvolve.org/wp/can-you-solve-this-problem-for-me/trackback/
March 9, 2010 at 3:01 pm
Matthew Slowe
Pivot table. The answer to every spreadsheet question is “pivot table”.
March 9, 2010 at 5:54 pm
peter clark
Step 1 – Download a trial version of IBM’s Tivoli Directory Integrator 7.x
Step 2 – Install
Step 3 – Define input sources (your spreadsheets)
Step 4 – Define output criteria
Step 5 – Execute code.