title: matlab concatenate each row from different excel file to new excel file
body: <p>I have a folder include 10 excel files. Each of the excel file contain 5 sheets. I would like to </p>
  
  <p>concatenate every 1st row in 1st sheet of each excel file into new sheet1 in new excel file named 'final'
  concatenate every 2nd row in 1st sheet of each excel file into new sheet1 in new excel file named 'final'
  concatenate every 3rd row in 1st sheet of each excel file into new sheet1 in new excel file named 'final' ....</p>
  
  <p>then </p>
  
  <p>concatenate every 1st row in 2nd sheet of each excel file into new sheet2 in new excel file named 'final'
  concatenate every 2nd row in 2nd sheet of each excel file into new sheet2 in new excel file named 'final'
  concatenate every 3rd row in 2nd sheet of each excel file into new sheet2 in new excel file named 'final' ....</p>
  
  <p>repeatedly...do for all 5 sheets...</p>
  
  <p>example:</p>
  
  <p>excel file 1, sheet1</p>
  
  <pre><code>30  4   1.6 1.2 1.2 1.0
  35  16  0.9 0.9 1.5 1.0
  40  62  0.9 0.9 1.6 1.2
  45  3   0.9 0.9 0.9 0.9
  50  1   1.5 1.5 0.8 0.8
  </code></pre>
  
  <p>excel file 2, sheet1</p>
  
  <pre><code>10  1   0.8 0.9 0.9 0.9
  15  31  0.9 0.9 1.2 1.6
  20  2   0.9 0.9 0.9 0.9
  25  3   0.9 0.9 0.9 0.9
  30  18  0.9 0.9 0.9 0.9
  </code></pre>
  
  <p>excel file 3, sheet1 to excel file 10, sheet 1 etc...</p>
  
  <p>the result i would like to get</p>
  
  <p>final.xls, sheet1</p>
  
  <pre><code>30  4   1.6 1.2 1.2 1.0  %1st row of sheet1 in excel file 1
  10  1   0.8 0.9 0.9 0.9  %1st row of sheet1 in excel file 2
  ... %repeated 1st row of sheet1 in excel file 3 to 10
  35  16  0.9 0.9 1.5 1.0    %2nd row of sheet1 in excel file 1
  15  31  0.9 0.9 1.2 1.6    %2nd row of sheet1 in excel file 2
  ... %repeated 2nd row of sheet1 in excel file 3 to 10
  </code></pre>
  
  <p>final.xls, sheet2</p>
  
  <pre><code>%similar to sheet1 just the data read from sheet2..
  </code></pre>
  
  <p>Does anyone can help me?</p>