Solved

How to move the columns to another column.

Posted on 2011-09-15
7
194 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
  • 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
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.

 
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 500 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

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

929 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

9 Experts available now in Live!

Get 1:1 Help Now