Technology KnowledgeBase

How do I turn tables in Excel to switch columns to rows and vice versa?

Have you found yourself in a situation where you had a table of data in Excel that you needed to switch columns to rows and vice versa? There's no need to re-enter all that data. What you need to do is transpose your data. Here's a Paste Special trick that will solve your problem in no time.

  1. Select the range of cells you need to transpose.
  2. From the Menu Bar, select Edit -> Copy.
  3. Select a cell where you want your new transposed data to start.
  4. From the Menu Bar, select Edit -> Paste Special and place a checkmark in the Transpose box at the bottom of the window.
  5. Click OK.

You may find that you have to do some minor formatting, such as adjusting column widths, to get everything looking perfect but you have just saved yourself a whole lot of work!

Attached Files
There are no attachments for this article.
MENU