Excel Forum
Similar Content
How to Add, Remove, and Rearrange Columns and Rows in Excel
Tutorial: Adding, removing and rearranging columns is as easy as resizing. You just select your colu...
Quickly Switch the Columns and Rows of a Data Set in Excel
Tutorial: How to switch a data set in Excel so that the columns become rows and the rows become col...
Quickly Resize Multiple Columns or Rows at Once in Excel
Tutorial: How to quickly resize multiple columns and rows at once in Excel.  This avoids having to...



Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions


See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and ROWS function. If you dont want to use TRANSPOSE function, this is a good substitute.





Got a Question? Ask it Here in the Forum.