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.

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.

Profile Photo for Lowell Heddings Lowell Heddings
Lowell is the founder and CEO of How-To Geek. He’s been running the show since creating the site back in 2006. Over the last decade, Lowell has personally written more than 1000 articles which have been viewed by over 250 million people. Prior to starting How-To Geek, Lowell spent 15 years working in IT doing consulting, cybersecurity, database management, and programming work.
Read Full Bio »