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. Just select your original data Press CTRL+C to copy Go to an empty area and open Paste Special (CTRL+ALT+V) Select Transpose. Done! Although this approach works, …