NxTranspose - Convert row to column (and vice versa)

Converts a vertical range of columns into a range of rows or vice versa.



is a range of cells (one or two-dimensional array) on a worksheet you want to transpose.


  1. The NxTranspose function must be entered as an array formula in a range with the same number of rows and columns, respectively, as the source range has columns and rows.
  2. Use NxTranspose to shift an array's vertical and horizontal orientation (or range) on a worksheet.
  3. The function maintains the original time order of the data set. 

Files Examples

Related Links



Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful