I have a csv file with over 100 names with different background/ demographic information (see sample example below):

| Name | Data | 2000 | 2001 |
| --- | --- | --- | --- |
| Pam | Job | Analyst | Associate |
| Jim | Job | Manager | Director |
| Steve | Job | Manager | Director |
| Dave | Job | Manager | Manager |
| Pam | Salary | 50000 | 65000 |
| Jim | Salary | 100000 | 120000 |
| Steve | Salary | 100000 | 120000 |
| Dave | Salary | 90000 | 90000 |

How can I filter the csv file by name (let’s say I only want to see Pam and Dave) and by data (Job only). Of course I want to do this on a large scale (ideally I’d like to filter the original file which has 100 names down to twenty specific names and the 20 data down to 10).