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.
… Read the rest...
- Just select your original data
- Press CTRL+C to copy
- Go to an empty area and open Paste Special (CTRL+ALT+V)
- Select Transpose.