Take Your Data from Row to Column or Vice Verse in Google Doc Spreadsheet
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.
About Article Author
It is very simple to convert a Google Doc Spreadsheet to Excel or PDF file format. Still we write this
A pro MS Excel user may find some difficulty in getting familiar with Google Spreadsheet. There are plenty of shortcut
Hope you are a regular reader of our Google Doc Spreadsheet tutorials. We already have some rich content there to
I am a power user of Microsoft Excel. That gives me much freedom in using the cloud powered Google Doc
Learn how to use important logical functions IF, AND, OR in Google Doc Spreadsheet. Logical functions are very easy to
Earlier we have learned how to create a Line Graph or Line Chart using Google Doc Spreadsheet. In this Google