Excel: Formulas for converting data among column / row / matrix ...

Are there formulas to convert data in a column to a matrix or to a row? And to convert ... How do transform a "matrix"-table to one line for each entry in excel.

stackoverflow.com