Welcome Guest ( Log In | Register )




Collapse

Top Submitters

· NickTheGreek (127)
·  (127)
· www.yourforum.gr (61)
· nickpar (20)
· Big (1)

Collapse

Random Tutorials

View Hidden 3D Benchmarks in Windows Vista

Tutorial name: View Hidden 3D Benchmarks in Windows Vista
Submitted by: NickTheGreek


Collapse

Announcments


Welcome to Tutorial System!


Print this Tutorial 

Convert a Row to a Column in Excel the Easy Way

Tutorial Information
Name: Convert a Row to a Column in Excel the Easy Way
Submitter: NickTheGreek
Category: Windows Tutorials
Submitted: 20 Aug 2012
Updated: 20 Aug 2012
Views: 331
Rating: This tutorial is unrated.
Convert a Row to a Column in Excel the Easy Way
View All Tutorials By This Member
View Discussion Topic
Description:
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.
Tutorial Instructions
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.

Source: http://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/
Comments
There have been no comments made as of yet. Why not be the first?



1 user(s) active
Active Users 1 guests, 0 members, 0 anonymous members
Sorted by Last Click
Quick Stats
Board Stats There have been a total of 244 tutorials in 6 categories and 0 sub-categories with 111356 views and 24 comments
The newest tutorial is How to Add “Move to” or “Copy to” to Windows 10¢s Context Menu by NickTheGreek

RSS Lo-Fi Version Time is now: 29th March 2024 - 11:43 AM
Skin and Graphics by Dan Ellis and Anubis. Hosting by Forums & More © 2005-2011.
InvisionGames - Your #1 Arcade Games Repository | AllSigs - Signatures for all | Rock Band + Guitar Hero = RockHero ! | The Remoters - Remote Assistance | FileMiners - You ask, We find