Friday, June 12, 2009

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 AllShow All

Hide AllHide 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

3 comments:

Alex said...

Some days ago I reinstalled my MS Excel and on unknown reasons a lot my data were corrupted.To my surprise myself helped-xlsx corrupted,this tool I found in own computer archives.As far as I remember tool is free and in addition it can both recover all these graphics, interviews, tables and reports in Microsoft Excel format.

Alexis said...

For work with excel files I usually use-can Excel files may be repair.Because tool is quite reliable and has free status.Moreover utility can too export recovered data into a new Microsoft Excel file.

Alexis said...

I was in situation,when I added one element into my MS Excel and after I reopened file and data was damaged.But I used the google and I found-repair Excel xls.Tool solved all problems in two minutes and made it without payment.Moreover tool demonstrated recover worksheets in Microsoft Excel format.