I'm new to SharePoint 2013 and working on a list for projects that our department has. Each project may have 1 to 6 contributors (each with a column in the list; primary, secondary, back up etc...) The columns are dropdowns of all team members we have.
Is there a way to sort the list by the name of each team member, which will show all projects he/she is involved with?