I'm struggling with designing a spreadsheet. I am cataloging quotes referred
to in various speeches and organizing them by topic.

My columns look like this:

Topic Quote Original Reference LDS Reference

My problem is two fold. First when I have the same quotation referenced by
two different speakers. Duplicating the original reference seems redundant
but is it necessary for recording the raw data.

The second problem is when a quote covers multiple topics. If something
refers to both pride and weakness. I can't put both topics in the same cell
and filter for pride because it records pride, weakness as a single entry.

I am expecting this to get to over a thousand quotes and need my design to
support that much data so having three topics columns is a pain. Is that the
only way?

I've been through tutorials and looked everywhere and am still in a quandry.

Do I just record everything separate and then use various sorting methods
and pivot table to interpret the data?


HELP!!!!