When you have a long range of data arranged in row wise and want to change it into column wise, you may have to apply lots of cut and paste. Wait! You only need to apply cut and paste if you are not aware of the “Transpose” function in Google Doc Spreadsheet. It’s very simple and easy to apply. You can count Transpose as one of the must to know function in Google Doc Spreadsheet as well as on Microsoft Excel.
There are two methods to arrange a data from column to row or row to column using Transpose. We will see both the options and decide which one is easy for you. To make an idea about Transpose, we will see how a data will look like before and after applying Transpose.
Screenshot 1 : Sample data before applying Transpose
Screenshot 2: How data will look like after applying Transpose
From the above example, you can clearly understand one thing. You can change data orientation from vertical to horizontal or horizontal to vertical in Google Doc Spreadsheet as above using Transpose. How?
Method 1: Transpose Array Function
In the above data (screenshot 1), if you apply the Transpose array function, it will look like;
Method 2 : Transpose in Paste Special
You can receive the same result by using the Paste Special. Copy the data you want to Transpose and go to the cell where you want the data to be transposed. Then Go to the Edit menu Paste Special > Paste Transpose.
This way you can quickly change your data orientation from row to column or column to row.
Note : This’s as part of our simplify Google Doc Spreadsheet series tutorials.