Excel Forum



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.