I have a list of tutors in a Google Spreadsheet:
Name | Address | Phone | Profile | Subject1 | Subject2 | Subject3 | ... | SubjectN
I would like to populate additional sheets with the name, address and phone data of each tutor that tutors a specific subject.
In sheet 1 I would put an
1 or whatever in the subject cell to indicate that the tutor covers that subject.
Each subject specific sheet would then be populated with the contact data of each tutor that covered that specific subject, but not others that did not have a mark in the corresponding cell in sheet 1.
This would give me a master list in sheet 1 that I could update, and subject specific sheets with a list of just the tutors that cover that specific subject. Most tutors cover more than one subject, but I do not need any sheets that reference multiple subjects.
I've seen various possible approaches for similar issues but none seem to match this situation.