Excel – Quickly transpose data using Paste function

Transposing data is easy using the built-in Transpose feature, but there is another way.  You can use Paste to transpose your data.

Excel tranpose data

  1. Select the data (table, spreadsheet) that you want to transpose.
  2. Copy it to the Clipboard using Ctrl+C. For instance, the example table (shown right) is in A3:E9.
  3. Select the top-left cell of the range you want to copy the transposed data to (A11 for instance).
  4. Click the Home tab (if necessary).
  5. Click the Paste drop-down in the Clipboard group.
  6. Click Transpose (the last icon on the second row).
  7. That’s it! Excel’s Paste feature quickly transposes the data.

Comments are closed.