I have a table like this:
1 2 3 4 5
A Y N N Y N
B N Y Y N Y
C Y N Y N Y
D N Y N Y N

I need it to look like this:

1 A Y
1 B N
1 C Y
1 D N
2 A N
2 B Y
2 C N
2 D Y
3 A N
3 B Y
3 C Y
3 D N

(etc.)

can anyone recommend a function to help automate the process?

i realize it's a combination of hlookup and something else, but i don't know what that something else might be.