TRANSPOSE - Excel - Microsoft Office Online

Find your self doing lots of cut-paste special-transpose in Excel?

TRANSPOSE( and CTRL-SHIFT-ENTER will be your friend.

TRANSPOSE

Applies to: Microsoft Office Excel 2003

Show All

Hide All

Returns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE must be entered as an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) in a range that has the same number of rows and columns, respectively, as an array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array on a worksheet.

TRANSPOSE - Excel - Microsoft Office Online