title: Excel: Formulas for converting data among column / row / matrix
body: <p>Are there formulas to convert data in a column to a matrix or to a row?
  And to convert from/to other combinations?</p>
  
  <p>What about an even more complex case: reshape a matrix of width W to width N*W?</p>
  
  <p>There are a few similar or related questions.
  I have answered some of them, marked with *.
  I keep updating this list, as new similar (or equal) questions are added:</p>
  
  <p><a href="https://stackoverflow.com/questions/20750687/formating-data-columns-to-rows">Formatting Data: Columns to Rows</a>  *</p>
  
  <p><a href="https://stackoverflow.com/questions/20666516/move-content-from-1-column-to-3-columns">Move content from 1 column to 3 columns</a>  *</p>
  
  <p><a href="https://stackoverflow.com/questions/20356632/how-to-split-one-column-into-two-columns-base-on-conditions-in-excel">how to split one column into two columns base on conditions in EXCEL</a>  *</p>
  
  <p><a href="https://stackoverflow.com/questions/18735590/writing-a-macro-to-transpose-3-columns-into-1-row">writing a macro to transpose 3 columns into 1 row</a></p>
  
  <p><a href="https://stackoverflow.com/questions/16612887/excel-vba-transpose-with-characters">Excel VBA transpose with characters</a></p>
  
  <p><a href="https://stackoverflow.com/questions/14873014/mathematical-transpose-in-excel">Mathematical transpose in excel</a></p>
  
  <p><a href="https://stackoverflow.com/questions/4623972/how-do-transform-a-matrix-table-to-one-line-for-each-entry-in-excel">How do transform a &quot;matrix&quot;-table to one line for each entry in excel</a></p>
  
  <p><a href="https://stackoverflow.com/questions/12613507/convert-columns-with-multiple-rows-of-data-to-rows-with-multiple-columns-in-exce">Convert columns with multiple rows of data to rows with multiple columns in Excel.</a></p>
  
  <p><a href="https://stackoverflow.com/questions/30497757/how-to-use-vba-to-reshape-data-in-excel">How to use VBA to reshape data in excel</a>  *</p>
  
  <p><a href="https://stackoverflow.com/questions/30522004/sorting-three-columns-into-six-sorted-horizontally-by-surname-using-excel">Sorting three columns into six, sorted horizontally by surname using excel</a>  *</p>
  
  <p><a href="https://stackoverflow.com/questions/11276359/divide-data-in-one-column-into-more-column-in-excel">divide data in one column into more column in excel</a></p>
  
  <p><a href="https://stackoverflow.com/questions/20912409/move-data-from-multiple-columns-into-single-row">Move data from multiple columns into single row</a>  *</p>
  
  <p>Some of the answers appear to be "upgradeable" to something more encompassing.
  Is that possible?</p>
  
  <p>Sample formats to convert from/to are:</p>
  
  <p>Column</p>
  
  <pre><code>1
  2
  3
  4
  5
  6
  7
  ...
  </code></pre>
  
  <p>Row</p>
  
  <pre><code>1   2   3   4   5   6   7   ...
  </code></pre>
  
  <p>Matrix (with a span of 4 columns here)</p>
  
  <pre><code>1   2   3   4
  5   6   7   8
  ...
  </code></pre>