Converts a vertical range of columns into rows range or vice versa.
X is a range of cells (one or two dimensional array) on a worksheet that you want to transpose.
- 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.
- Use NxTranspose to shift the vertical and horizontal orientation of an array or range on a worksheet.
- The function maintains the original time-order of the data set.