• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Move a column in a table

X

xina

New Member
I often will import data into a spreadsheet from our ERP system (e.g. supplier, stock code, supplier catalog number). Never fails that later someone wants to add another field(e.g. description). No problem, but it always ends up as the last column. How do I move it to where I need it (i.e. supplier, stock code, description, catalog number)? The query shows it where I want it but it doesn't view correctly in the spreadsheet.


Thanks!

Xina
 
Hi, xina!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


Despite of this, there are a few considerations:

a) how do you perform the import process? if at Excel directly from your ERP system, please post the detailed steps or the macros involved; if importing a previously exported .xls*, .csv, .txt or other file from your ERP please post a sample and its structure

b) no matter how, you could always cut & insert cut columns within your worksheet so as to arrange its order or sequence


Regards!
 
Good day xina


Right click on the column header and select cut, then right click on the header on column to the right (excel will put the column to the left of the one you have chosen) and from the drop down choose Insert Copied Cells.
 
how it is exported will likely depend on that particular software.


as far as moving it to the desired location once its in Excel; R-click on the column heading, cut, R-click on the Column heaing to the right of where you wish to move the new field too and Paste (choose the Insert Cut Cells option)


EXAMPLE

A | B | C | D |

First Name | Location | Item | Description |


If i want to move the 'Description' Field so that it is between Col.A and B i would cut COl.D and R-click on Col.B and Paste.


yeah, what bob said!! lol
 
From reading the OP I don't think they have any problem with importing the data, they just want to quickly reorganize the columns that have been added by other users. jason I do not see where the OP is talking about exporting, please point the way :(
 
@b(ut)ob(ut)hc

Hi, old dog!

Good afternoon, my friend.

Did you mean OP or ORIGINAL POSTER? There're a lot of OP, I guess that one by topic, but ORIGINAL POSTER there's only one. :p

Regards!
 
SirJB7- I couldn't find the search box for the life of me. I thought it very odd it wasn't obvious. Turns out it isn't there in Firefox, my main browser. I pulled the site up in Explorer and there is was, in an obvious place :)


I did a search and still not seeing the answer to my question.


Bobhc- I tried that but getting an error still.


Let me elaborate :)


I import my data from Microsoft Query/ODBC. Pull in the fields I need. When I complete the steps Bob mentioned I get the following error.


"The operation cannot be completed for one of the following reasons:

- A selection including cells both inside a table and below it cannot be copied and inserted into that table. Select cells outside the table and try inserting the data again.

- You have attempted to fill data in a way not supported by the table."


I would like to maintain the data in a table so I can refresh the data pull. It seems I can turn the table into a range, move the column, and return the data to a table. I'm afraid by taking the data from table to range to table I'm losing the integrity of the links and ability to refresh (pull new data from our ERP).
 
SirJB7 my friend I quote:-


"Good afternoon, my friend.

Did you mean OP or ORIGINAL POSTER? There're a lot of OP, I guess that one by topic, but ORIGINAL POSTER there's only one"


I seem to recall a certain gentleman from Argentina asking, not so many post ago, what OP stood for. :)
 
Hi, xina!

Give a look at this file, it's the map to the lost treasury:

https://dl.dropbox.com/u/60558749/Move%20a%20column%20in%20a%20table%20%28for%20xina%20at%20chandoo.org%29.png

Regards!
 
SirJB7


Good evening old friend, I think you need to refresh your browser, seems to have black marks all over it, :)
 
@b(ut)ob(ut)hc

Hi, old dog!

Good afternoon again for you.

Black marks? Maybe they're food splatter... but I don't remember eating black caviar today... neither yesterday... nor this week... month or year, I said?

Regards!

PS: But if I did, the read one did a perfectly shaped splashing :)
 
You must log in or register to reply here.
Back
Top