Solved

How to move the columns to another column.

Posted on 2011-09-15
7
197 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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 create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

696 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