Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,276
Default move numbers from row to column

Hi Paul,
Copy, paste special, transpose

If this was helpful please click yes. thanks

"Paul" wrote:

I forgot how to do it.
I have a set of numbers say 10 numbers.
Each number is put in each of the 10 ranges in a horizontal row.
I would like to move them into each of the 10 ranges in a vertical column.
How?
Thanks.



--
Paul

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default move numbers from row to column

ok. done. thanks. amigo.


"Eduardo" 在郵件
ä¸*撰寫...
Hi Paul,
Copy, paste special, transpose

If this was helpful please click yes. thanks

"Paul" wrote:

I forgot how to do it.
I have a set of numbers say 10 numbers.
Each number is put in each of the 10 ranges in a horizontal row.
I would like to move them into each of the 10 ranges in a vertical
column.
How?
Thanks.



--
Paul


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
move text & numbers in column to separate columns deb Excel Discussion (Misc queries) 5 January 16th 09 05:31 AM
Move only numbers to a new column Outlook, eh? Excel Worksheet Functions 3 October 2nd 07 07:11 PM
numbers in a column and it changes when I move to the next column confused Excel Discussion (Misc queries) 1 August 5th 06 04:46 AM
move list of numbers from one column to multiple columns coach eo Excel Discussion (Misc queries) 12 February 16th 06 08:12 PM
how can i move the starting point for the numbers numbers down. Gold9er Setting up and Configuration of Excel 1 November 22nd 05 10:09 PM


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"