Pivot vs formulae

[Lir85]

Hello, I am trying to create a table where I will have event category (A,B) and each category will have projects. The table should work off the raw date or pivot. My question is how to lookup a list of all projects for the specific category,i.e. when projects get added they are added to my table automatically...Hope that makes sense.. Any hint would be really appreciated

Example:
Category A
Project1
Project2
Project3

Category B
Project1
Project2

[Olly]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.