Solved

can I convert column to row in EXCEL?

Posted on 2001-07-17
1
820 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
drag and drop a row in excel 2010 5 41
the UDF returns #Value when i open workbook. 19 42
Userform to show a range in excel. 3 29
Office 365 Spam 3 25
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

738 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