Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robin
 
Posts: n/a
Default Can I rearrange data entered in rows into colums in Excel?

Hello, we've got a great deal of data entered in rows but need to
automatically (if possibly) rearrange it so that it is set up in columns. Is
there any way to do this?
Thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
FiluDlidu
 
Posts: n/a
Default Can I rearrange data entered in rows into colums in Excel?

Edit-Paste Special
then check TRANSPOSE in the dialog box that comes up

"Robin" wrote:

Hello, we've got a great deal of data entered in rows but need to
automatically (if possibly) rearrange it so that it is set up in columns. Is
there any way to do this?
Thanks

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
Importing Microsoft query data into excel changes linked rows Wazzy_bear Links and Linking in Excel 1 December 19th 05 09:09 AM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
output date modified if data is entered for multiple rows [email protected] Excel Discussion (Misc queries) 4 October 13th 05 08:09 PM
Can I copy data from only the visible rows in Excel? Sarah Excel Discussion (Misc queries) 1 October 8th 05 09:23 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 09:36 AM.

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"