Transpose Excel Column to Row or Row to Column

By -
If you have a worksheet & you need to rearrange the column into row or vice versa. The flip flop between the rows & column seems time consuming & tiring process but in real it is not. As the Microsoft Excel provide you the automated transpose option in its tools bar which enable you to rearrange your column into row or row into column with its transpose feature in Paste Special option
.

Suppose this is the worksheet with row “Sales in Month” & Column “Sales in Region”

If you discover that it would be better if Sales in Region could become Row & Sales in Month is represented in Column like this

The transposed result should seems like this:

See How to Change the orientation of row & Column in Excel


Step1: Select the row & column which you want to transpose

Step2: Then press keyboard shortcut command for Copy i.e. “Ctrl+C”

Step3: Then Select the other position where you want to Paste

Step4: Right click & select the “Paste Special ” option

Step5: Then another window of “Paste Special” pop up. Check the Transpose checkbox

Step6: See the result, the transposed rows & columns shown as output


Comments

Post a Comment

Popular posts from this blog

How to Repair Excel Strict Open XML Spreadsheet ?

By -
Image
File Format In Microsoft Excel Workbook Microsoft Excel application is utilized for spreadsheet management. When users create a new worksheet in Excel, it can be saved in two main formats of XLSX. One is Excel Workbook (.xlsx) and another is Strict Open XML Spreadsheet (.xlsx) . These two formats are a bit different from each other.  How Strict Open XML Spreadsheet is Different ? The ordinary Excel Spreadsheet is called the transitional variant while Strict Open file is known as the strict variant. As the file name suggests, there are some restrictions in Strict Open Excel files. For example, Strict XLSX file contains graphics done by DrawingML, as VML is not supported. This file format also contains UNICODE Characters only. Strict XLSX also does not allow legacy techniques. User Query 1: “I am in urgent need to open some Excel files. I keep getting this error message whenever I attempt to open those files: Strict Excel Spreadsheet .xlsx is not valid. I do not k...
Read more

Can I Copy And Paste a List of Email Addresses from Excel To Outlook?

By -
Image
“Hello, I have recently joined an organization, in which I have to take records of thousands of contacts. And for easy management, I keep those contacts list in Microsoft Excel file. But recently there is a need to transfer all email addresses from Excel contacts to Outlook account. Therefore, I want to know, can I copy and paste a list of email addresses from Excel to Outlook? If yes, then how?” Now let’s start. Sorry, the answer is no. You cannot copy and paste the email address from the Excel sheet to Outlook, but you can import them to Outlook contacts. In this blog, we will discuss various solutions available to import contacts from Excel spreadsheet to Outlook contacts . So first let's discuss the manual solution and the difficulties which come with it. Import Contacts (Email Addresses) From Excel File to Outlook Open the Microsoft Outlook & go to the File menu Choose open & Export category from the dashboard Hit on the import/export. Select Import from...
Read more