Binary Symmetricl Matrix combination in Excel 2007

**supernovartis** · 09-05-2013, 07:43 AM

Hi everyone,

I have the following matrices (binary, symmetric, with different dimensions)

y1 g24
y1 0 1
g24 1 0

y1 c1 c2 l17
y1 0 1 1 1
c1 1 0 1 1
c2 1 1 0 1
l17 1 1 1 0

I would like to combine them to form a bigger matrix that looks like this:

y1 g24 c1 c2 l17
y1 0 1 1 1 1
g24 1 0 0 0 0
c1 1 0 0 1 1
c2 1 0 1 0 1
l17 1 0 1 1 0

Is this possible in Excel?

Thank you in advance.

**Debraj Roy** · 09-05-2013, 08:06 AM

Hi..

So in both matrix.. matched data's cross center (in your case y1) will always be same.. In above case 0..
so that we can ignore duplicate data in next matrix!!

	y
y	X

**supernovartis** · 09-05-2013, 08:23 AM

Hi, yes cross center data will be same "0" The point is I have tens of these small matrices (binary, symmetric, different dimension) with recurring variables (names), and would like to generate a bigger matrix which removes duplicates but somehow keeps (or sums if it's simpler) the original values of each small matrix.