Converts a vertical range of columns into a range of rows 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 with 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.