Take Your Data from Row to Column or Vice Verse in Google Doc Spreadsheet

0
1179
spreadsheet logical functions

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.

spreadsheets

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

sample data for transpose

Screenshot 2: How data will look like after applying Transpose

transposed data example

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

Transpose (array)

In the above data (screenshot 1), if you apply the Transpose array function, it will look like;

=transpose(B3:D8)

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here