Quickly Transpose ‘THE MATRIX’

Thanks again to Chandoo for his superb trick. This is just a replication of his post.

Excel has a built-in feature that lets you transpose data with a single click.


  1. Just select your original data
  2. Press CTRL+C to copy
  3. Go to an empty area and open Paste Special (CTRL+ALT+V)
  4. Select Transpose.
Read the rest...