I am a sheet that looks like:

2/17 2/18 2/19 2/20 2/21 2/22
Sue A A A A
Sally P P P
Peter A
Mary A P P P
Pat A A A
Marie A A A
Liz P P P
Marjorie P P P P

On a second sheet I want to list the names of the people who have an "A" or
"P" such as:
2/17 - A 217 - P 2/18 - A 218 - P 2/19 - A 2/19 - P
1 1 1 1 1 1
2 2 2 2 2 2
3 3 3 3 3 3
4 4 4 4 4 4
5 5 5 5 5 5

Thanks for any help!