Tuesday, 29 January 2013

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:

No comments:

Post a Comment