need to change order of columns from csv file

[need-some-help!]

We download a csv file from Authorize.net but the header columns do not match
the format we need to import into our Mail Order Manager software. We need to
selectively pull columns from the csv and put into a new file that we can
import into MOM. We will need to do this each day. I have been reading about
macros and pivot tables and am not sure if either can help me.

Thanks to anyone who can help...Chris

 

[Pete_UK]

Do you not read your previous posts ??

Check this one out:

http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/693d6e9ca26c8a95#

Hope this helps.

Pete

 

[Joel]

The macro is the best approach. It is very simple to copy columns from one
workbook to a new workbook. Let me know which columns from your original
workbook need to be put into the new workbook. It will only take a few
minutes to generate this type of macro.

 

[Bernard Liengme]

Suppose the imported data is on Sheet1

Method 1
On Sheet2 in A1 enter =Sheet1!B1
On Sheet2 in B1 enter =Sheet1!A1
Copy this down the column to row 20
Compare the two sheets; does this suggest a solution?

Method 2
On Sheet1 insert a new row 1
Type this words in to A1, B1, C1, D1: zebra, dog, cat, ape
Select from A1 across to D and down to the last row
Use Data | Sort ; specify left to right (in option) and then sort by Row 1
Does this suggest a solution?

Please come back if you need more details
best wishes

 

[Shane Devenshire]

Hi,

When you import your csv file you can specify in the wizard which columns to
skip on the last step.

Once in just put numbers at the top of each column indicating the order you
desire, for example, 5, 2, 1, 4, 3

Select your data with the top row being the above numbers and choose Data,
Sort, Options, Sort Left to Right.