?
Solved

How to move the columns to another column.

Posted on 2011-09-15
7
Medium Priority
?
200 Views
Last Modified: 2012-06-22
I have this Excel .xls sheet that has 2000 rows of data.
But I need to change the order of the columns to use it for a data import. Example:

I have a "ProductName" column on column "C"
I need to make the "ProductName" column the "A" column.

I have move the order of all the other 23 columns around too.

What is the best way of doing this? thanks
0
Comment
Question by:MikeMCSD
[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
  • 4
  • 3
7 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 36544404
Add a row
Number the rows where you want them to be
Sort the data left to right on the number.

Which excel version are you on?

Thomas
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36544414
0
 
LVL 16

Author Comment

by:MikeMCSD
ID: 36544430
thanks Thomas,
Excel started 2010 (97 - 2003 worksheet).

When you say "Number the rows where you want them to be",
do you mean letters like "A", "B", etc.?
I need to move the columns to letters like A, AG, BE, etc..

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 39

Expert Comment

by:nutsch
ID: 36544514
Problem with two letter columns is that they'll show up in between the other ones, as in A AA AC B BB BD, etc.

You can solve that by entering your one letter columns with a space before, or use numbers instead.

Check attached screencast

T
nutsch-500410.flv
0
 
LVL 16

Author Comment

by:MikeMCSD
ID: 36544605
Thanks for the nice video, but I'm really not understanding this at all.

Would this work :

I selected the whole column (C) with all the rows , copied it,
then pasted the whole column into another column (A) on another sheet.
It seems to have worked.
Is there anything work with doing it this way?

0
 
LVL 39

Accepted Solution

by:
nutsch earned 2000 total points
ID: 36544679
If your columns are pure data without formulas, I don't see any issues doing it that way.

If you want to rearrange on the same page, you can select the column, click on the left or right edge of the selection and drag to the destination with the Shift key pressed, this will insert the column where you want it.

T
0
 
LVL 16

Author Closing Comment

by:MikeMCSD
ID: 36546152
thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

764 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