Tag Archives: Transpose

How to transpose Excel table using Paste Special -feature

There is a handy way to transpose entire table:

  1. Select the table you want to transpose
  2. Select Copy
  3. Select Paste Special (e.g. from the context menu)
  4. Mark checkmark to Transpose
    –> And vĂ³ila, you have transposed table!
Following video demonstrates this: