dalenguyen
New Member
- Joined
- Oct 5, 2016
- Messages
- 1
Hi, I have sample table like this:
<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:
<tbody>
</tbody>
I'm not sure how or where to start by using formula. Please help. Thanks,
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,