• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

How to move the columns to another column.

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
MikeMCSD
Asked:
MikeMCSD
  • 4
  • 3
1 Solution
 
nutschCommented:
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
 
MikeMCSDAuthor Commented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
nutschCommented:
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
 
MikeMCSDAuthor Commented:
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
 
nutschCommented:
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
 
MikeMCSDAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now