How to convert columns to rows in Google Sheets and vice versa

Just like in Excel, converting columns to rows , with data on Google Sheets, users can also convert columns to rows and vice versa with a very simple function formula. When performing the conversion function, data from vertical rows will be converted to vertical columns, without disturbing the user's data. The following article will guide you to convert columns to rows in Google Sheets and vice versa.

 

Instructions for converting rows to columns in 1 Sheets

Step 1:

First you create content in Google Sheets data table as usual.

Step 2:

Next, in the cell showing the successful row conversion content, enter the formula =TRANSPOSE(A29:C30) . Then press Enter to execute this function.

Step 3:

The horizontal content results have been converted to columns as shown below.

 

With data from columns to rows, users also enter the same formula. You just need to select the data area you want to convert.

How to convert rows to columns to new sheet

In case the converted content is too long and does not fit in the same Sheet, you can move it to a new Sheet.

Step 1:

First, users need to rename the sheet in Google Sheets , if the default name is according to Google Sheets.

Step 2:

Then switch to another sheet and enter the formula =TRANSPOSE(Page1!A25:C29) and press Enter as shown below.

 

The content in sheet Page 1 has been transferred to Page2 with the row content converted to columns as shown below.

How to fix #REF error converting rows to columns in Google Sheets

When you convert rows to columns in Google Sheets, you will get a #REF error and cannot execute the command as shown below.

The #REF error converting rows to columns in Google Sheets is caused by misspelled sheet name in the function formula, or the converted data area is overwritten with the area with data.

So you have to check the data area and sheet name again when entering the formula.

After converting columns to rows, if you want to manipulate or calculate on the new data table, copy the new table , paste it to another area or paste it over the current table, and when pasting, select Paste values ​​only . Then you can manipulate the table as usual.

Above is how to convert data from horizontal to vertical rows on Google Sheet, with just 1 very simple TRANSPOSE function. If you have difficulty converting columns to rows on Google Sheet, please comment below the article for support.

Good luck!