Create Sharepoint View sorted by fixed values across several columns

Question

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?

Answer 1

You can filter each column by every value this column has.

Just click in the title name and select the value you want to filter.