Can I group by contact in a report if the contact is not always in the same column?
I am trying to run a report from a sheet that contains many projects and different columns for each role within those projects. I have some staff members who serve in different roles in different projects. (For example, Abby is "research lead" on project A, but "Research Advisor" on project B.) I want to be able to run a report that groups projects by different people. That way I have a list of all the projects Abby is working on and all my other team members. However, right now Reports is only letting me group by different columns.