taking special average of numbers

I have two field in dataser as below.

the answer you see as C labeled row, is A1*B1 + A2*B2 + A3*B3 = weightedA A1 + A2 + A3 = totalA so C1 = weightedA/totalA

now do the same for next 3 numbers and so on.

How do i do that in matlab?

Answer 1

[Andrei Bobrov]

ab = randi(100,2,12); % here ab - your array
ab2 = permute(reshape(ab,2,3,[]),[2 3 1]);
ab(3,3:3:end) = dot(ab2(:,:,1),ab2(:,:,2))./sum(ab2(:,:,1);