Convert a Row to a Column (or Backwards) in Google Docs Spreadsheets
- by The Geek
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:
=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)
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.
Similar Articles
Productive Geek Tips
How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips]Integrate Google Docs with Outlook the Easy WayHow To Export Documents from Google Docs to Your ComputerConvert a Row to a Column in Excel the Easy WayScroll Backwards From the Ubuntu Server Command Line
TouchFreeze Alternative in AutoHotkey
The Icy Undertow Desktop
Windows Home Server – Backup to LAN
The Clear & Clean Desktop
Use This Bookmarklet to Easily Get Albums
Use AutoHotkey to Assign a Hotkey to a Specific Window
Latest Software Reviews
Tinyhacker Random Tips
DVDFab 6
Revo Uninstaller Pro
Registry Mechanic 9 for Windows
PC Tools Internet Security Suite 2010
Check Your IMAP Mail Offline In Thunderbird
Follow Finder Finds You Twitter Users To Follow
Combine MP3 Files Easily
QuicklyCode Provides Cheatsheets & Other Programming Stuff
Download Free MP3s from Amazon
Awe inspiring, inter-galactic theme (Win 7)