MATLAB: Format Questions

Question

MATLAB has strict format requirement.

1. A and B are in double format. C is in cell format. (C is read by: [~,C,~] = xlsread('C:\XXX\XXX.xlsx','Sheet1','M2:X2')

A = 
[10
15
20
25
30];
B = [1423992 1356920 1356920
440353  436518  436518
1325369  1307792  1307792
1485221  1165422  1162373
1496009  1489431  1489431
6170946  5756085  5753036
];
C ='SECTOR' 'MKVALM'  'DVYDC'  'DVYLD500'

How can I combine A, B and C to get a matrix D so that:

D = 
SECTOR MKVALM DVYDC DVYLD500
10 1423992 1356920 1356920
15 440353  436518  436518
20 1325369  1307792  1307792
25 1485221  1165422  1162373
30 1496009  1489431  1489431
SUM 6170946  5756085  5753036

Notice that the D(7,1) = 'SUM'.

2. Once I get D, I want to add an empty row and a row with numbers to get E,

E = SECTOR MKVALM DVYDC DVYLD500
10 1423992 1356920 1356920
15 440353  436518  436518
20 1325369  1307792  1307792
25 1485221  1165422  1162373
30 1496009  1489431  1489431
SUM 6170946  5756085  5753036
35  12  12  14

Notice there is an empty row between 'SUM 6170946 5756085 5753036' and '35 12 12 14'.

Any help will be appreciated!

Answer 1

Ac = num2cell(A);
Bc = num2cell(B);
D = [C;Ac,Bc(1:end-1,:);{'SUM'},Bc(end,:)];
E = [D;cell(1,4);{35, 12, 12, 14}];