Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Thanked 0 Times in 0 Posts
    I have many .csv files every month that I import into Excel to review. Majority of the fields are aligned so that the data is in the correct column. However there are always a number of rows in these .csv files that do not align with the rest. I must then go in and manually put the fields in the correct location. They are usually the same number of fields off but not always such as the row starts in Column D instead of column A.
    Is there some way I can do something to align these rows? I don't know if there is something I can do before I import the file or if I need to do something once it's in Excel.
    I would appreciate any help you could give as this is a very time consuming job.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    [quote name='CCJ' post='764410' date='09-Mar-2009 18:45'][/quote]
    Welcome to the Lounge!

    I suspect there's something wrong with the .csv files - if the data don't align correctly in Excel, they don't align correctly in the .csv file, so unless you can have a say over the source of the .csv files I don't think there's much you can do about it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts