Google Drive and Docs Tips
How to transpose data in a Google spreadsheet
Excel has a useful transpose feature when copying and pasting. Here's a tip to do the same in a Google spreadsheet.
Some features you may have used in Microsoft Excel are not immediately obvious in a Google spreadsheet, the team at gAppsTips are here to help you make the switch as painless as possible. Let's say you have a table that would look better if the row and column data was switched around, in Excel you would copy and paste choosing the transpose method but in a Google spreadsheet we can use a formula.
To transpose data from a table spanning cells A1 to E8 in a Google spreadsheet use the following method:
- choose an appropriate cell that you want the data to start in eg A10
- type in the following formula: =TRANSPOSE(A1:E8)
- press enter to complete your formula
- the table will be transposed into the appropriate span of cells for your table.