• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Office » How to Transpose Columns to Rows in Excel

How to Transpose Columns to Rows in Excel

By: Waseem Patwegar

After entering data, you may find that you had incorrectly put the data meant for Columns in Rows or vice versa. An easy way to fix this error is to Transpose Columns to Rows in Excel.

Transpose Columns to Rows in Excel

Transpose Columns to Rows in Excel

As you can see in the image below, the original data input has “Item Names” appearing as Column Labels and “Months” appearing in Rows (3 to 7).

However, the actual requirement was to have the “Months” appearing as Column Labels and Items Names appearing in Rows.

Example of Data Input in Excel

When faced with such problem, many users try to re-arrange the data into required format by painfully copying and pasting data rows and columns.

However, copying and pasting a large amount of data is tedious and can also give rise to errors. A better solution to fix the data is to make use of the Transpose option as available in Paste Special menu in Excel.

1. Open the workbook containing incorrectly arranged data.

2. Select the entire data set, right-click on your selection and click on Copy option in the drop-down menu.

Copy Selection in Excel

3. Next, click on a New Location in the worksheet where you want to paste the data, right-click and choose Paste Special… option in the drop-down menu that appears.

Paste Special Command in Excel

Note: Alternatively, you can use the keyboard shortcut Ctrl + Alt + V.

4. On Paste Special screen, select the Transpose option and click on the OK button.

Transpose Option in Excel Paste Special Command

You will now see the Transposed Data pasted in your selected location.

Original and Transposed Data in Excel

Note: You will be required to apply formatting as required, adjust column widths and edit column headings to suit your requirements.

In above example, we have demonstrated the use of Transpose Function to rearrange data running into multiple columns and Rows.

You may be pleased to know that Paste Special and Transpose option can also be used to convert a single Row of Labels into a Column, or vice versa.

Related
  • How to Remove Duplicate Entries in Excel
  • How to Start New Line in Excel Cell

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Recent Posts

  • Fix: iPhone Camera Black Screen Problem
  • How to Clear Your Activity History In Windows 11
  • How to Find WiFi Password in Windows 11
  • How to Enable Touch Keyboard in Windows 11/10
  • How to Send Group Email In Gmail App On iPhone




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved