
Not All
IT Companies
are the Same.
Get 30 Years of Expertise Immediately.
Fill in the form below and we will get to work right away.
CPU respects your privacy. We will never sell, rent or share to ANYONE. You can trust us.
Productivity software can be found in pretty much every business. While there is usually a bundle of software available, the most useful is arguably the spreadsheet. Google users have a solid spreadsheet program in Google Drive. However, at first glance you may think this is missing some key features, such as the ability to transpose data. In truth, it actually is there, just slightly hidden.
If you are unfamiliar with Transpose, a popular feature found in other spreadsheet programs like Microsoft’s Excel, it allows users to switch, or flip, selected rows and columns quickly and easily. While this may seem like a feature that you wouldn’t use too often, it can be a big help, especially when it comes to graphing and creating charts.
If you have ever painstakingly entered information into columns and rows, then gone to visualize it in a chart or graph and realized that it looks terrible, and it would look better if it was reversed, transpose can make this process easier.
How to transpose rows and columns
To transpose rows and columns in Spreadsheet, you first need to have data entered. From there you can:
It is a good idea to be aware of whether you need to flip cells with text, say label cells, as well. Simply select these cells, along with the data cells, and Spreadsheet will take care of the rest.
If you want to copy the data from the new cells into the old cells, don’t simply copy and paste the cells, as this will actually delete all the information. Instead, select the new cells and copy them as you usually would. When you go to paste, right-click on the first cell, hover your mouse over Paste special, and selectPaste Values Only. This will paste ONLY the numbers and words, but it won’t take the formatting. You should then be able to go and delete the transposed cells you previously created.
Transpose can be a useful feature, especially if you need to quickly flip data in cells. If you would like to learn more about Google Spreadsheets, or any of the other Drive products, please contact us today.
Published on 30th July 2013 by Jeanne DeWitt.