Conditional Lookup

[Tracey]

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!

 

[Tracey]

My message was a little unclear......

One sheet looks like this:

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

I want to pull the info across so that a second sheet ends up with the names
of people who have an "A" or "P" and therefore give me a this:


2/17 - A 2/17 - p 2/18 - A 2/18 - P 2/19 - A 2/19 - P
Sue Liz Sue Marjorie Peter Sally
Mary Marjorie Pat Pat Mary
Pat Marie Marie

Thanks Again.