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)