Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2014, 08:51 AM
jimmydd2121 jimmydd2121 is offline Moving from Rows to Columns Mac OS X Moving from Rows to Columns Office for Mac 2011
Novice
Moving from Rows to Columns
 
Join Date: Jun 2014
Posts: 1
jimmydd2121 is on a distinguished road
Default Moving from Rows to Columns


I have a list of numbers in one column down many rows. How do I cut and paste these numbers to fit across many columns and one row? So, the numbers will be listed horizontally not vertically stacked, if that makes sense.
Reply With Quote
  #2  
Old 06-02-2014, 09:05 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Moving from Rows to Columns Windows 7 64bit Moving from Rows to Columns Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hello you can use : Copy - Paste special - Transpose or the TRANSPOSE function Demo : http://www.excel-easy.com/examples/transpose.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving from Rows to Columns Changing rows into columns paapachak Word Tables 8 01-06-2014 02:44 PM
Moving data from multiple rows to 1 row for each program number ballj_35 Excel 3 08-01-2012 05:10 AM
Moving from Rows to Columns Moving columns plantzj Word 3 09-17-2011 10:30 AM
Moving from Rows to Columns Rows to Columns kyakobi Excel 5 12-07-2010 03:12 PM
Moving from Rows to Columns Table rows moving to new page when you don't want them to graham Word Tables 1 11-16-2009 08:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft