Lookup function to reshape data

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.

Sorry, my example did not include any cell names.

So in the first table, cell A1 = 1. Cell B1 = 2. Cell C1 = 3. Meanwhile, Cell A2 = A. Cell B2 = Y. Cell C2 = N.

And in the second table, Cell A1 = 1. Cell B1 = A. Cell C1 = Y. Cell A2 = 1. Cell B2 = B. Cell C2 = N, etc.

Does that help clarify?