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.



  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    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

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- 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