While working with data, sometimes you may need to transpose data in Google Sheets.
But you don’t need to do this manually.
In this tutorial, I will show you two great ways to transpose data in Google Sheets:
Suppose you have a dataset as shown below:
Transposing this data would mean that you would have the names in one row and the score below it in another row.
Here are the steps to transpose data in Google Sheets:
This will transpose the dataset.
Note that when you use the above steps, it only transposes the data, but does not carry the formatting with it. You will have to copy the formatting separately.
Also, the transposed data is static. This means that in case the data changes, then you will have to repeat these above steps again to get the new transposed data.
In case you want the transposed data to be dynamic, use the TRANSPOSE function as shown below.
Again, let’s suppose we have the same data (as shown below):
Here are the steps to transpose data using the TRANSPOSE function:
This would instantly transpose the data.
Google Sheets automatically identifies the number of rows/columns in the data set and the transposed data takes up the corresponding number of rows/columns in the transposed data. In case there is already some data in the cells that are to be used by the TRANSPOSE function, you will get a #REF! error.
Also, note that you can not delete a part of the array of the transposed data. If you want to delete the transposed data, you will have to delete the entire data set.
You May Also Like the Following Tutorials:
Using FILTER Function in Google Sheets (explained with Examples)
How to Search in Google Sheets and Highlight the Matching Data
How to Use OR Function in Google Sheets (with Examples)
How to Use IMPORTRANGE Function in Google Sheets (with Examples)
How to Use IMPORTDATA function in Google Sheets