Transpose table in Excel

For the sake of better efficiency, simplicity, or just visual ease, sometimes you may need to flip tables between horizontal and vertical axes. In excel you can use the transpose function to rotate tables so the entire layout changes from horizontal to vertical. This small feature can save you a lot of time, as the process is simple and takes only a few seconds. Here’s how it works.

– Select the entire table that you want to convert to either column or row format.

– Copy the table by right click copy or Ctrl+ C after selecting the table.(Note that “Cut” will not do the job.)

–  Now either from the right click menu or the Home tab on the Ribbon select Paste Special.
EXCEL
– In the Paste Special box check the Transpose box and then click OK.
If you see an error, you may need to select a box outside of the original table before attempting to Transpose again.
EXCEL 2

Your newly arranged table should appear in the spreadsheet, and that’s all there is to using the Transpose feature in Excel 2013. The same process applies in excel 2010.

Job Done. Now sit in a mermaid position and give orders.

Leave a Comment

Your email address will not be published. Required fields are marked *

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

More Posts

Benefits of Password Complexity

We’re sorry, your password must contain an uppercase letter, a number, a metaphor, a graffiti, a hieroglyph and the blood of a witch. Yes, but why? Password-cracking software uses one of three approaches: intelligent guessing, dictionary attacks, and brute-force automated attacks that try every possible combination of characters. Given enough time, the automated method can

Reach out

Re-Architect

This methodology requires the most effort to implement but it results in the most optimised recurring cost and will provide the best scalability for apps. This involves re-adapting the code of applications and the heavy use of SAAS solutions in order to replace existing hosted applications.

Re-Platform

This method utilizes the power of  PAAS services, like transferring a database to an as-a-service model,  the use of containers for some apps or the use of network/security functions as a service. Greater scalability and lower cost of operation is achieved.

Re-Host (Lift & Shift)

the migration of workloads from  to the cloud without changing the architecture. Machines get to keep their  OS and apps. This is the quickest and easy way to migrate, but since its  utilising IAAS, its is also the most expensive on the long term.