TRANSPOSE Function (Functions in Excel)

	Jan	Feb
Alan	10	30
Bob	40	50
Carol	70	80
Total	120	160
0	Alan	Bob	Carol	Total
Jan	10	40	70	120
Feb	30	50	80	160
{=TRANSPOSE(C3:E7)}
		As an array formula in all these cells

What Does It Do ?

This function copies data from a range, and places in it in a new range, turning it so

that the data originally in columns is now in rows, and the data originally in rows

is in columns.

The transpose range must be the same size as the original range.

The function needs to be entered as an array formula.

To enter an array formula you must first highlight all the cells where the formula is required.

Next type the formula, such as =TRANSPOSE(A1:A5).

Finally press Ctrl+Shift+Enter to confirm it.

If changes need to be made to the formula, the entire array has to be highlighted, the edits

can then be made and the Ctrl+Shift+Enter used to confirm it.

Syntax

=TRANSPOSE(Range)

Formatting

No special formatting is needed.

Related Posts by Categories