I have two matrix

matrix A (first matrix)

col1 col2 col3 col4 col5 col6 col7 col8 col9 col10

1 11 1 16 8 11 5 16 9 13

2 12 9 11 2 19 7 12 3 14

3 17 2 13 1 18 4 13 1 11

4 16 10 18 9 17 1 11 5 15

4 14 2 14 7 18

3 19 6 17 4 12

6 110 6 16

8 110

2 17

10 19

11 111

matrix B (second Matrix)

col1

1

2

3

4

5

6

7

8

9

10

11

now i want to compare these two matrix but only alternative column. Matrix B col1 with Matrix A col1, col3, col5, col7, col9

and want to get an output in this format

col2 col4 col6 col8 col10

1 11 16 18 11 11

2 12 13 19 14 17

3 17 19 0 0 14

4 16 14 0 13 12

5 0 0 0 16 15

6 0 110 0 17 16

7 0 0 0 12 18

8 0 0 11 0 110

9 0 11 17 0 13

10 0 18 0 0 19

11 0 0 0 0 111

(NOTE:: please paste this matrix in excel sheet then u might be able to see the rows and column in apt way)

More Neetika Nath's questions See All
Similar questions and discussions