• ARTICLES
SEARCH

How-To Geek

Convert a Row to a Column (or Backwards) in Google Docs Spreadsheets

If you have to deal with a lot of spreadsheets, you’re probably really bored right now. You also might be wondering how to turn a row into a column, or a column into a row. Here’s how to do it with Google Docs Spreadsheets.

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.

image

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

=TRANSPOSE(

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:

=TRANSPOSE(A1:A11)

image

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.

image

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

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 04/29/10

Comments (3)

  1. Eric

    I really enjoy your articles, but please don’t be greedy with the RSS page length per topic. If you want people to see your advertising and links, maybe just put a Teaser in the RSS feed and have people click over to see the full article. This is what a lot of other feeds do to great success. It’s annoying to scroll through lengthy articles and redundant links and ads in Google reader.

    I have a habit of deleting feeds that don’t have a positive usefulness over annoyance quotient..

  2. Phantom

    Excellent article, thank you for sharing.
    See you later.

  3. Aqualung

    How do you do this for the whole table though?

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!