Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default how entries in a column can be put into a row

dear all
I have some long data in a column and i want it to put into a row. can i do
this by a command or two with going to cut and past the individual entries???
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how entries in a column can be put into a row


Hi,

Try with "copy" and "paste special" with transpose check box checked.

Rgds,

Vobiscu

--
Vobiscu
-----------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187056699

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
Counting entries in column based on condition in another column RobertR Excel Worksheet Functions 1 February 8th 07 03:54 PM
Count entries in one column based on values in another column Kurt Excel Worksheet Functions 7 January 10th 07 09:29 PM
Locking column entries to an adjacent linked column Steeljaw Excel Discussion (Misc queries) 1 January 23rd 06 10:45 PM
how entries in a column can be put into a row AFZAAL Excel Programming 2 June 27th 05 10:34 AM
Allow only 12 entries in a column Gary[_16_] Excel Programming 3 April 18th 04 05:49 PM


All times are GMT +1. The time now is 03:36 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"