If you’re like most people, you probably use Google Docs to keep track of important business information. But what if you want to convert a row to a column in your spreadsheet? There are a few steps you can take to do this:

  1. Choose the right sheet in your Google Docs document. The first step is to choose the sheet that will contain your data. This will depend on the type of spreadsheet you’re using, but typically it’ll be called “Sheet 1.”
  2. Drag the row or column that you want to convert into a column on the left side of your sheet. This will create a new column in your spreadsheet.
  3. Click on the arrow next to the column name and select “Convert Row To Column.” This will change the field name in the cell for that row from “Row” to “Column.”

If you’re an Excel user, you’re also in luck, because we’ve already shown you how to turn a row into a column, or vice-versa. It won’t make you any less bored though.

Convert a Row to a Column (or backwards)

The first thing you’ll need is a column or a row of information that you want to convert into the opposite. For our example, we’ve got this set of data that we created by using the Auto Fill options in Google Docs.

Now in another cell, you’ll need to use the TRANSPOSE function, which you can use by simply typing in the following:

And then selecting the cells with the mouse, or manually typing in the range of cells you want to copy. The final function in this example was:

Finish it off with the final ) character to complete the function, hit the Enter key, and there we are… the column was transposed over to the right.

You can use the same thing to turn columns into rows, or rows into columns—just change the range you are looking for.