How to Transpose in Google Sheets

You might need to transpose the data of your rows and columns to a different location in the sheet. This is done to present a set of data in a better way. 

2 Methods of Transposing Data in Google Sheets:

  • Using the transpose formula
  • Using paste special

Method 1: Using the Transpose Formula

The Transpose Formula is a useful method if you want to reflect changes made in the original data to the transposed data as well. It can be seen as a ‘live copy’ as ongoing changes show in the transposed data too.

Step 1: Open your Google Sheet

To transpose your data, open a new Google Sheet, or open an existing sheet with the data you want to transpose.

Step 2: Choose the destination cell

Choose the cell where you want to transpose the data.

Here, the destination cell is A13, which means that the transposed data will appear here.

Step 3: Enter the formula

Enter the formula =TRANSPOSE(range) in the selected cell to transpose the data.

Step 4: Choose the cells containing data

Use your cursor and select the range of cells constituting the data you want to transpose to the new location, including the headings.

In our example above, you will see the selected range here is A1 to B9.

Step 5: Hit Enter

As soon as you hit Enter, your selected range of data will be transposed to your desired destination.


Method 2: Using Paste Special

If you use paste special, any changes to the original data will not affect the transposed data. 

Step 1: Open your Google Sheet

Open a new sheet or an existing one in which you want to transpose your data.

Step 2: Copy the dataset

Select the range of cells constituting the data you wish to transpose, including the headings. Copy the data by right-clicking with the mouse or by using the keyboard shortcut Ctrl+C.

Step 3: Choose the paste transposed option

Right-click on the destination cell where the transposed data must go. 

A menu will appear with various Paste options.

Choose the option Paste special, and then Transposed

This will transpose your copied data to the set of new cells.


Conclusion

Transposing data in Google Sheets is extremely simple, but you must decide whether you want to keep the data ‘as-is’ or not.

Pick the first method if you want changes in the original data reflected on the transposed data. Pick the second one if you don’t want changes in the original data reflected on the transposed data. 

Let us know in the comments which method you used to transpose your data!

Leave a Comment