How To Rotate Data Tables in Google Sheets

Last Updated on November 3, 2023 by Jake Sheridan

In this tutorial, you will learn how to rotate data tables in Google Sheets.

An organization of information or data called a table is usually made up of rows and columns, though it may sometimes have a more sophisticated structure. Tables are frequently used in data analysis, research, and communication.

Once you are ready, we can jump right into learning how to rotate data tables in Google Sheets.

Rotate Data Tables in Google Sheets

Before we start, we will need a data table that we will use to rotate.

Step 1

Make sure your data is organized to easily transpose the data table.


Step 2

Now we need to select the desired data table, which is A3:C4, and right-click to select Copy.


Step 3

Then, we select the cell we want to paste the transposed data table in, in our case, it is A9.


Step 4

We then right-click and select Paste special, then select Transpose.


Step 5

Once you have selected Transpose, the data table will be transposed and look like this.



That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

This tutorial covered how to insert a new comment in Google Sheets. Want more? Check out all the Google Sheets Tutorials.