Rows To Columns In Google Sheets

What Is Rows To Columns In Google Sheets?

Rows to columns in Google sheets, as the name suggests, is a method to convert rows and columns into columns and rows, respectively. This method is useful to present the data effectively and easily, without worrying about re-entering the data again. Converting rows to columns, otherwise, known as transpose can be done using an inbuilt function or using paste-special method.

For example, consider the below table showing subject and marks in columns, A and B, respectively.

Now, let us learn how to convert rows to columns, such that row 1, 2, and 3 will become column A, B, and C, respectively. To begin with, select the data range A1:B3 and copy using Ctrl + C shortcut keys. Then, paste it into the desirable cell in the spreadsheet using the Transposed option under the Paste Special category under the Edit tab.

We will be able to see the result, as shown in the image below.

In this article, let us learn how to convert rows to columns with detailed examples.

How To Convert Rows To Columns In Google Sheets?

We can convert rows to columns in Google sheets using two methods. They are:

• Using Paste Special
• Using TRANSPOSE formula

#1 – Using Paste Special

We can convert rows to columns in Google sheets using paste special method with the following steps. They are:

Step 1: To begin with, we need to enter the data in the spreadsheet. Next, we need to copy the cell range.

Step 2: Then, select the cell where we want to copy the converted cell range.

Step 3: Next, click on the Insert tab and select the Paste Special option.

Step 4: Then, select the Transposed option.

We will be able to see the converted data in Google sheets.

Likewise, we can convert rows to columns using paste special method.

#2 – Using TRANSPOSE Formula

We can convert rows to columns in Google sheets using the TRANSPOSE function formula with the following steps. They are:

Step 1: To begin with, we need to enter the data in the spreadsheet.

Step 2: Then, select the cell where we want to have the converted cell range.

Step 3: Next, enter the TRANSPOSE function by typing =TRANSPOSE and select the cell range which we want to convert.

Step 4: Press Enter key.

We will be able to see the converted data in Google sheets.

Likewise, we can convert rows to columns using the TRANSPOSE function formula in Google sheets.

Examples

Now, let us learn how to convert rows to columns in Google sheets with the following detailed examples.

Example #1

For example, consider the below table showing directions in the 1^st row (R1), respectively.

Now, let us learn how to convert rows to columns in Google sheets, such that the data is converted into column A, respectively.

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:D1. Next, we need to copy the cell range. In this example, we need to select A1:D1 range using the shortcut keys Ctrl + C.

Step 2: Then, select the cell where we want to copy the converted cell range. In this example, let us select the cell A4.

Step 3: Next, click on the Insert tab and select the Paste Special option.

Step 4: Then, select the Transposed option.

We will be able to see the converted data in Google sheets, as shown in the below image.

Likewise, we can convert rows to columns using paste special method in Google sheets.

Example #2 – Convert Multiple Rows To Columns In Google Sheets

For example, consider the below table showing name and sales in the 1^st row (R1), respectively.

Now, let us learn how to convert multiple rows to columns in Google sheets, such that the data is converted into column A, respectively.

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B5. Next, we need to copy the cell range. In this example, we need to select A1:B5 range using the shortcut keys Ctrl + C.

Step 2: Then, select the cell where we want to copy the converted cell range. In this example, let us select the cell A8.

Step 3: Next, click on the Insert tab and select the Paste Special option.

Step 4: Then, select the Transposed option.

We will be able to see the converted data in Google sheets, as shown in the below image.

Likewise, we can convert multiple rows to columns using paste special method.

Example #3 – Convert Rows To Columns From One Google Sheet To Another

For example, consider the below table showing product and price in the 1^st row (R1), respectively.

Now, let us learn how to convert rows to columns from one Google sheet to another sheet, such that the data is converted in another sheet, respectively.

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cell range A1:B5. Next, we need to copy the cell range. In this example, we need to select A1:B5 range using the shortcut keys Ctrl + C.

Step 2: Then, select the sheet where we want to copy the converted cell range. In this example, let us select the Data sheet. Next, click on the cell A1.

Step 3: Next, click on the Insert tab and select the Paste Special option.

Step 4: Then, select the Transposed option.

We will be able to see the converted data in Google sheets, as shown in the below image.

Likewise, we can convert multiple rows to columns using paste special method in Google sheets.

Example #4

For example, consider the below table showing quarter and projects in columns, A and B, respectively.

Now, let us learn how to convert rows to columns in Google sheets, such that row 1 and 2 will become column A and B, respectively.

Step 1: To begin with, we need to enter the data in the spreadsheet. In this example, the data is available in the cel range A1:B5.

Step 2: Then, select the cell where we want to have the converted cell range. In this example, let us select the cell A7.

Step 3: Next, enter the TRANSPOSE function by typing =TRANSPOSE and select the cell range which we want to convert.

Step 4: Press Enter key.

We will be able to see the converted data in Google sheets, as shown in the below image.

Likewise, we can convert rows to columns using the TRANSPOSE function formula.

Important Things To Note

• Convert rows to columns in Google sheets converts the rows into columns.
• The TRANSPOSE function in Google sheets just converts the rows into columns.
• But, the function does not copy the formatting we have done such as font style, font size, font color and background color.

Frequently Asked Questions

Recommended Articles

• Google Sheets IMPORTRANGE + AI: Cross-Sheet Mastery
• SUMXMY2 in Google Sheets
• TBILLPRICE in Google Sheets
• YIELDMAT in Google Sheets