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

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,860
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Dec 8, 2009

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.

  • likes, 1 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • Hi, I have a more complicated set of data that requires transposing

    here is how it looks like: paste2. org/p/1215016

    have you done sth like this in any of your videos?

  • No i do not. No problem. Try THE best Excel question site:

    mrexcel[dot]com/forum

see all

All Comments (4)

Sign In or Sign Up now to post a comment!
  • @ExcelIsFun

    I'll do that, thx

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more