How to Convert Data From Column Into Row In Excel 2007

Its a great tips for the data entry user who work in Excel 2007. Convert Data From Column Into Row In Excel 2007. Suppose user type data into Column after completed they thought that it would be better into Row then if they try to retype manually then it will take more time and will be very typical for user. This tips help user to Convert Column in Row .
Convert Data From Column Into Row In Excel

Convert Data From Column Into Row In Excel 

 
Read Also
1. First of all Open your data in Excel which you want to Convert in Row.
 
Convert Data From Column Into Row In Excel
 
 
 
 
 
 
 
 
 
 
 
 
 
2. Now Select Column which you want to Convert into Row then Right-click  and then Copy .
 
Convert Data From Column Into Row In Excel
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
3. Now Select Cell where you want to put data into Row then Right-click on cell and then Click on Paste Special … .
 
Convert Data From Column Into Row In Excel
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
4. Now on the Paste Special Dialog Box Select Transpose check Box and the Click on Ok .
 
Convert Data From Column Into Row In Excel
 
 
 
 
 
 
 
 
 
 
 
 
 
5. Now you will see that Column has been converted into Row.
 
Convert Data From Column Into Row In Excel
 
 
 
 
 
 
 
 
 
 
 
 
Column of data has been converted into Row . you can also convert Row Data into Column through this process .
Share This onShare on FacebookTweet about this on TwitterShare on LinkedInShare on RedditShare on StumbleUponShare on Google+Pin on PinterestBuffer this pageShare on Tumblr
Rakesh Kumar
at
Rakesh Kumar is a Network engineer and a Blogger. He is crazy for learn and write about Technology , Tech and Computer Tips and Tricks Blog.