Results 1 to 2 of 2

Thread: Importing data with merged cells

  1. #1

    Importing data with merged cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an online application that I am importing to excell. Each line item is supposed to import into a single row spanning accross multiple columns. However, I have one column that chooses to import onto multiple rows. This prevents me from using any sorting functions on the data, which is the reason I am importing to excel in the first place. This problem cell is a narrative that splits accross multiple cells for some reason. The only solution I have found so far is to invidually merge the multiple cells for each line item. This would take days as I have thousands of line items. Please advise.

    Thanks,

    Greg

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    Is there any commonality to the split rows that could be used to draft a rule to fix them? If so, we could write a macro to rejoin them, but only if there is a definable pattern. If you'd have to do each row by hand because there is no definable logic, then I'm afraid that you are possibly out of luck.

    If you have a sample of the data we can look at, it might help to upload it so we can see...
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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