NxTranspose - Convert row to column (and vice versa)

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

 

Syntax

NxTranspose(X)

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

 

Remarks

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

Files Examples

References

Have more questions? Submit a request

0 Comments