Solved

can I convert column to row in EXCEL?

Posted on 2001-07-17
1
814 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
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

771 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

7 Experts available now in Live!

Get 1:1 Help Now