NxTranspose - Convert row to column (and vice versa)

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 you want to transpose.

Remarks

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

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