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:

Leave a Reply

Your email address will not be published. Required fields are marked *