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

- 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.

## Files Examples

## Related Links

- What to do About Missing Values in Time Series Cross-Section Data , James Honaker and Gary King, American Journal of Political Science

## References

- Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
- Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740

## Comments

Article is closed for comments.