Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa. Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.
Please Note: This is tested in Excel 2003, 2007, and 2010. Here we took screenshots from Excel 2010 x64, but it works the same on the other versions.
Convert a Row to a Column
Here’s our data in Excel:
We want to change these two columns into rows. Select all the cells you wish to convert, right-click, and select copy (or simply press Ctrl+C):
Now, right-click in the cell where you want to put the data in rows, and select “Paste Special…”
Check the box at the bottom that says “Transpose”, and then click OK.
Now your data that was in columns is in rows!
This works the exact same for converting rows into columns. Here’s some data in rows:
After copying and pasting special with Transpose selected, here’s the data in columns!
This is a great way to get your data organized just like you want in Excel.
Similar Articles
Productive Geek Tips
Convert Older Excel Documents to Excel 2007 FormatHow To Import a CSV File Containing a Column With a Leading 0 Into ExcelExport an Access 2003 Report Into Excel SpreadsheetMake Row Labels In Excel 2007 Freeze For Easier ReadingKeyboard Ninja: Insert Tables in Word 2007
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
Revo Uninstaller Pro
Registry Mechanic 9 for Windows
PC Tools Internet Security Suite 2010
PCmover Professional
Increase the size of Taskbar Previews (Win 7)
Scan your PC for nasties with Panda ActiveScan
CleanMem – Memory Cleaner
AceStock – The Personal Stock Monitor
Add Multiple Tabs to Office Programs
The Wearing of the Green – St. Patrick’s Day Theme (Firefox)