Another interesting question from a friend – If you have a Microsoft Excel spreadsheet and you realize your data should have it’s axes reversed (the data currently arranged vertically should be arranged horizontally), are you stuck retyping it or doing ugly cut & paste work for a long time?

Nope

The easiest way I’ve found to accomplish this switch is to make use of Excel’s own paste functionality.

  • Select all your data
  • Right click and choose “Copy”
  • Go to a new page in the spreadsheet and right click on the cell you want as the upper left cell
  • Select “Paste Special” from the context menu that popped up when you right clicked
  • Select “Transpose”
  • You’ll note that your data is now on the opposite axis from its original position.