Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Turning a row's contents into a column of entries

Using Excel 2002 --

Is there a simple way to copy the contents of the cells along a row so
that they will be appear as entries in cells running down a column?
Is it possible to do the reverse as well?

Musawwir Spiegel

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,480
Default Turning a row's contents into a column of entries

Hi

Copypaste SpecialTranspose

--
Regards
Roger Govier

"Musawwir Spiegel" wrote in message
...
Using Excel 2002 --

Is there a simple way to copy the contents of the cells along a row so
that they will be appear as entries in cells running down a column?
Is it possible to do the reverse as well?

Musawwir Spiegel


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Turning a row's contents into a column of entries

Thank you so much. You have saved me a lot of time.

Musawwir

"Roger Govier" <roger@technology4unospamdotcodotuk wrote:

Hi

Copypaste SpecialTranspose


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
row's won't unhide terie Excel Discussion (Misc queries) 0 June 13th 07 03:42 PM
Turning column contents into text list separated by a comma Kevin Rhinehart Excel Discussion (Misc queries) 1 January 16th 07 07:00 AM
copy row's value Nicawette Excel Discussion (Misc queries) 2 June 13th 06 11:05 AM
Return entries from one named range based on the contents of another Sam Crump Excel Worksheet Functions 1 March 6th 06 04:00 PM
Turning a row into a column? While importing? Crafty Excel Discussion (Misc queries) 1 October 3rd 05 07:54 PM


All times are GMT +1. The time now is 11:07 PM.

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

About Us

"It's about Microsoft Excel"