Pull Out MATLAB Data to One Excel Spreadsheet[HELP!]

Your opinion is important to me!

First there is a MATLAB code(pseudo code):

    for i = 1:2
    A(i) = [C(i);D(i)];
    B(i) = [E(i);F(i)]; 
    end

The value for A and B in each loop are as follows,

    A(1) =     
    'Rank'    'Ticker'    '201205'    'Weight'
    [   1]    'B'         [ 0.04]     [       0.03]
    [   2]    'E'         [ 0.01]     [       0.10]

    A(2) =     
        'Rank'    'Ticker'    '201206'    'Weight'
        [   1]    'X'         [ 0.02]     [       0.07]
        [   2]    'Y'         [ 0.01]     [       0.11]

    B(1) =     
    'Rank'    'Sector'    '201205'    
    [   1]    'S'         [ 0.02]    
    [   2]    'A'         [ 0.01]   

    B(2) =     
        'Rank'    'Sector'    '201206'  
        [   1]    'T'         [ 0.08]   
        [   2]    'Y'         [ 0.03]

Now comes to my question. How can I add a code in the loop so that all values of A and B generated from each loop can be pulled out into a single spreadsheet like the following picture?

The trick thing is data should be pulled out in different area of spreadsheet for different i.

BTW this is a simplified version. The actual problem has 500 loops instead of 2. A and B are much more complicated as well.

Answer 1

[Mark Whirdy]

Append rows of empty cells {''} to the A, B cell-arrays as necessary

e.g.

    repmat({''},1,3)