title: How to convert a matrix to a single column using Excel
body: <p>I have the following matrix in Excel:</p>
  
  <p><strong>3 Columns:</strong> A, B, C</p>
  
  <p><strong>Row 1:</strong> a b c</p>
  
  <p><strong>Row 2:</strong> d e f</p>
  
  <p><strong>Row 3:</strong> ghi</p>
  
  <p>What I need is a single column with all these values. The result should look like that:</p>
  
  <p>a</p>
  
  <p>b</p>
  
  <p>c</p>
  
  <p>d</p>
  
  <p>e</p>
  
  <p>f</p>
  
  <p>g</p>
  
  <p>h</p>
  
  <p>i</p>
  
  <p>The TRANSPOSE function doesn't work for that case. I tried out the INDIRECT function, but did not find a solution. I would rather prefer to handle it with standard Excel formulas than with a makro.</p>
  
  <p>Any ideas?</p>