I have two sets of data that I want to cross-reference. The sets of data are the number of chapters and the names of characters that appear in those chapters. I want to be able to view data point "Chapter 1" and see what characters appear there (such as Kyra, Betty, John, Garic). Then I want to be able to view data point "Kyra" and see what chapters she appears in (Chapter 1, Chapter 2, Chapter 4, etc.).
Currently, I have the data arranged in two separate lists (which is obviously very ineffective). Is there a way to combine these data points into a single format so that they are all together and navigable? There are hundreds of each data point, and creating a matrix (the kind with every data point on both axes and an X where they overlap) would be obviously very inefficient.
Current format:
excel.png
Bookmarks