Generate new table from a current table in excel

[dalenguyen]

Hi, I have sample table like this:

ID	1	2	3
1	0	1	0
2	1	1	1

<tbody>
</tbody>

Then I want to generate a new table from that table. It will take the second row (1) then compare with each column (1, 2, 3) then print value of the matrix ( 0 - 1 - 0 ). For example:

Row_ID	Column_ID	Value
1	1	0
1	2	1
1	3	0
2	1	1
2	2	1
2	3	1

<tbody>
</tbody>

I'm not sure how or where to start by using formula. Please help. Thanks,