Is there a way to emulate a junction table in Excel?

[JenniferMurphy]

ChatGPT has provided me with some excellent information. I now have about 50 chats on all kinds of subjects. The ChatGPT sidebar, which is the only chat “catalog”, is essentially useless if I have more than 10-15 chats. I want to create my own catalog. The best tool is a database, because it can “join” multiple subjects to multiple chats. But my access skills are not yet up to that challenge. Word is the easiest, but its tables are kinda limited.

So, I am going to give Excel a try. My plan is to have one “master” table with one row for each chat. It would have fields like Date, Title, Status, Rating, Comments, & Link (the chat URL).

I also want a Subjects field that I can sort on and filter on. I thought about just having a Subjects field, but that would be more difficult to sort on or filter on. I think I need a separate Subjects table that contains the valid subjects, like Science, Math, History, Politics, Access, Excel, Word, & ChatGPT. I think the main challenge is how to “connect” multiple subjects with multiple chats. In Access, I would have a subjects table and a junction table to make the connections.

Is there any way to emulate a junction table in Excel?

Or, is there another way to do what I want to do?

 

[alansidman]

If you use Power Pivot to create a pivot table of your data, then you can build a junction table using Power Query and load it to the Data Model. This is explained in the Ken Puls video I have linked below.