How To Convert Rows To Columns In Google Sheets

Google Sheets is a superb various for premium spreadsheet packages. The net-based spreadsheet has a number of options, together with altering the information in your worksheet. Amongst these, Sheets has a particular function to transform rows to columns and vice-versa! 

As an illustration, in case your colleague switched the rows and columns throughout information entry, Google Sheets has the function to transform rows to columns simply.

How to Convert Rows to Columns in Google Sheets?

There are two methods you’ll be able to work your means by the difficulty. The Transpose function is answerable for changing your rows to columns and vice versa in Google Sheets. You might apply the strategies we’ve talked about on Google Sheets throughout all gadgets.

Paste Particular

The paste particular is a definite function on Google Sheets. This function is used to change or extract solely particular values from the pasted information. In our case, we use the paste particular function to make use of Transposed. 

Consult with the steps talked about beneath to make use of the paste particular function on each your desktop and cell/pill:

On Desktop

1. In your browser and navigate to Google Sheets.
2. Open your doc.
3. From the sheets, choose the information you want to change the alignment for.
4. Should you’re a Windows consumer, use the Ctrl + C command to repeat the information. Mac customers can use Command + C to repeat the choice.
   
5. Proper-click on a unique cell and choose Paste particular.
6. From the fly-out menu, click on on Transposed.

On Cell/Pill

1. Open the Sheets utility in your machine to open your doc.
2. Drag the anchor level to pick the desk you wish to convert.
   
3. Faucet on the chosen worth and choose Copy.
   
4. Faucet on a brand new cell you wish to paste the worth, then faucet on it once more to show the menu. Choose Paste particular from the tray.
   
5. Choose Paste transposed.
   

In each cases, Google Sheets will mechanically paste the transformed worth in your sheet. Should you want to delete the previous information desk, choose them as you probably did earlier than.

• On a desktop, right-click on the chosen cell and select from the Delete choices.
  
• For cell, faucet on the chosen desk and choose Clear.

TRANSPOSE Operate

Google Sheets has a devoted operate to transform the alignment of a desk. Should you like utilizing formulation to get one thing performed on spreadsheets, utilizing the TRANSPOSE operate is your technique. 

You should use this operate throughout all gadgets whereas utilizing Google Sheets. The steps talked about beneath are the identical for all gadgets:

1. On an open doc, choose the cell you wish to paste the transformed desk from.
2. Enter the method with the TRANSPOSE operate on this format:
   =TRANSPOSE(vary)

To go the vary as an argument, you’ll be able to merely choose the desk you wish to convert. Sheets will mechanically enter the chosen cell areas contained in the parameters.

Points That Could Come up Whereas Changing Alignment

Some points can come up once you attempt to convert alignments in Google Sheets. If the strategies we talked about above don’t be just right for you, you need to’ve run throughout a problem. Beneath, now we have listed points you’ll be able to encounter whereas making use of the talked about strategies.

#REF! Error

Sheets shows the #REF! error when it doesn’t find the cell you’ve referred to. Should you transfer or delete the desk after you’ve used the method with the TRANSPOSED operate, you’ll encounter this problem.

Bear in mind, the worth you get from utilizing the method makes use of the handed cells as its supply. Should you clear the worth, the method may have no worth to check with utilizing the TRANSPOSE operate.

Should you simply used deleted the desk, you’ll be able to undo the motion by hitting the Ctrl + Z key mixture.

#NAME? Error

Should you come throughout the #NAME? error message in Google Sheets, you want to perceive that there was a typing error within the method. Asides from the typing error, you may also encounter the #NAME? error with incorrect syntax.

Choose the cell with the #NAME? error to evaluate the method from the method bar. Examine for any typing error within the title of the operate. Additionally, examine should you’ve accurately used the syntax.

‘Transposed’ Not Accessible

Did you not see Transposed from the paste particular menu? This can be as a result of the sheet is open or greater than a single tab on the machine you’re presently utilizing. Shut the opposite tabs which have the sheet open and check out once more to make use of the paste particular function.

How to Change Alignment Between Two Sheets?

If the desk you wish to convert the rows into columns is on a unique sheet, you’ll be able to once more use the TRANSPOSE operate to modify the alignment. Though the method’s course of stays the identical, you want to watch out when passing arguments contained in the operate.

Use the method on this format:

=TRANSPOSE(Sheet!vary)

Contained in the parentheses, you first have to enter the sheet title after which add the exclamation signal (!) after the title. Then, enter the vary the desk is positioned within the sheet. Bear in mind, the one image separating the sheet title and the vary is the exclamation mark (!)