New project! My boss would like a citeable notes file. She was told this could be done nicely using a pivot table (though the example she was given looks like a regular filtered range to me). Ideally, she would like to be able to click on a key word and see – in a friendly and uncluttered way – all the quotes attached to it. Or click on a source ID and see the citation, or whatever.
I’ve watched the pivot table videos and don’t know how to do what she wants. I’m hoping I just missed it (Excel can do everything!).
Attached is an excerpt from what I’ve done so far: just putting the information in a table. It was felt that the pivot table is ugly. I guess the problem is visual: filtering necessitates looking at extra junk, and I don’t know how to make a pivot table look nicer.