Solved

How to move the columns to another column.

Posted on 2011-09-15
7
193 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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
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.

746 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

12 Experts available now in Live!

Get 1:1 Help Now