Hi everyone! I have a list of programs and for each of them, a list of names that worked on the program, anywhere between one and four people. If I want to synthesize this data and know, for example, what programs should i ask "Geoff" about, how do I do this in Excel?
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
Program | Person A | Person B | Person C | Person D |
Program CNBC | Angela | Geoff | ||
Program CNN | Ashley | Shelby | Geoff | |
Program ZTV | Ashley | Shelby | Angela | Chris |
Program ESPN | Geoff | James | ||
Program Fox | Ashley | Shelby | Chris |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>