How to Transpose (Reverse places) Columns and Rows Using Paste Special in Excel

How to Transpose (Reverse places) Columns and Rows Using Paste Special in Excel

After Exporting  the data from Text to Excel sheet you realized the you have transposed columns and rows. Instead of putting names at the top of each column, you put dates, or vice-versa. The same goes for rows -- instead of adding the data you wanted in the column, you’re now stuck with a row-formatted data entry.

With Excel, you might think the only option is to copy/paste the entries into the correct place, or start over. That is cumbersome and error prune.  There’s a really easy fix in the Paste Special menu that allows you to reverse your mistakes without starting over.

1. Now Copy the entire data set by selecting the area.

2. Click on a new location in the sheet to add your transposed data.
3. Right click and choose Paste Special.

4. At the bottom of the Paste Special box, check the Transpose option.

5. Press OK to transpose the columns and rows.