Solved

can I convert column to row in EXCEL?

Posted on 2001-07-17
1
815 Views
Last Modified: 2007-11-27
hi, everyone,
I want to convert one column to one row in EXCEL2000, for example, convert
1
2
3
to
1 2 3
automatically?

thanx a lot.
0
Comment
Question by:WanNing
1 Comment
 
LVL 13

Accepted Solution

by:
cri earned 100 total points
ID: 6292294
Select 1,2,3 and copy to clipboard
Then select top cell of target area and apply Edit|PasteSpecial|Transpose

Is this 'automatical' enough ?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Printing calendar search results in Outlook 2010. 1 48
MS Office 2013 for purchase 3 56
Index Match Vlook up for a master file 7 60
Excel Error per WinZip Add-In 9 59
Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now