Friday, July 31, 2009

DevTnT 9 – Transpose Functionality in Excel

In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.

This can be useful especially if you have to copy rows from a database with a large number of fields. The transposed row-oriented result may be easier to read as the default column-oriented view:

transpose

  1. Highlight the cells that you want to copy.
  2. Then right-click on the cell where you'd like to paste the values and select Paste Special from the popup menu.
  3. Then select the Transpose checkbox and click on the OK button.

1 comment:

  1. The upgraded three-point platform leveling system is now extra intuitive than ever and the all-new heat resistant... The ORION™ Delta 3D Printer is an exciting and engaging new 3D printer from the oldsters at SeeMe CNC that's designed to electric fireplace print ABS, PLA, and different supplies from the very beginning. There's no have to refine or do something to your printer - so you actually have a ton extra options for material than you usually do with an unmodified 3D printer. "Every side of the method has been considerably improved by having this capacity within our facility," John Wahl VI, tooling engineer at Auburn Hills, concluded.

    ReplyDelete